query("select product_name,p.id,mrp_price,sell_price,size,size_type from tbl_product p join tbl_productprice pp on p.id=pp.product_id where p.status=1 and pp.status=1 and p.storeid='$storeid'"); $number_of_rec=$obj->numRows($prod); ?> No result find fetchNextObject($prod)){?> product_name;?> size;?>size_type;?> $sell_price;?>