query("select stores.storeid from tbl_store_zip left join stores on tbl_store_zip.storeid=stores.storeid where stores.sectionid like '%1%' // and tbl_store_zip.zone_status=1 and tbl_store_zip=.store_status=1 and tbl_store_zip.status=1 and stores.status=1"); // // echo $zipstore; // $record = $obj->numRows($zipstore); // if ($record > 0) { // while ($storeresult = $obj->fetchNextObject($zipstore)) { // array_push($storesearcharr, $storeresult->storeid); // }//while loop // $storesearcharr = implode(',', $storesearcharr); // $storeWhare = "and tbl_product.storeid in ($storesearcharr) "; // }//$r // $query = $obj->query("SELECT * FROM $tbl_product WHERE product_name like // '" . $_POST["keyword"] . "%' AND status = '1' $storeWhare ORDER BY product_name LIMIT 0,10"); $query = $obj->query("select storeid,product_name,product_id,photo,in_stock,tbl_productprice.id, mrp_price,sell_price,size,size_type from tbl_product join tbl_productprice on tbl_product.id=tbl_productprice.product_id where tbl_product.status=1 and tbl_productprice.status=1 and product_name like '%" . $_POST["keyword"] . "%' group BY product_name LIMIT 0,15"); ?> fetchNextObject($query)) { ?> product_name ; ?>