View file File name : ajax-stp.php Content :<?php include("../include/config.php"); include("../include/functions.php"); $storeid=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['storeid']); ?> <?php $prod=$obj->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); ?> <?php if( $number_of_rec==0){?> <option value="">No result find</option> <?php }else{ ?> <?php while($resprod=$obj->fetchNextObject($prod)){?> <option value="<?php echo $resprod->id;?>"><?php echo $resprod->product_name;?> <?php echo $resprod->size;?><?php echo $resprod->size_type;?> $<?php echo $resprod->sell_price;?></option> <?php } } ?>