Search Results for:

query($sql); } if ($page == "") { $page = 1; $low = 0; $high = $num; } else { $low = (($page - 1) * $num); $high = $page * $num; } if ($category == "All") { $sql = "select distinct p.asin, p.price, p.url, p.image3, p.title, p.inventory from tblProducts p where p.adminhold = 0 and p.included = 1 and p.inventory > 0 and p.price > 0 and (p.title like '%".$term."%') $sortby limit $low, $num"; $totalcountsql = "select count(distinct asin) from tblProducts where adminhold = 0 and included = 1 and inventory > 0 and price > 0 and (title like '%".$term."%')"; } else { $sql = "select distinct p.asin, p.price, p.url, p.image3, p.title, p.inventory from tblProducts p where p.adminhold = 0 and p.included = 1 and p.price > 0 and p.inventory > 0 and (p.title like '%".$term."%') and p.category = '".$category."' $sortby limit $low, $num"; $totalcountsql = "select count(distinct asin) from tblProducts where adminhold = 0 and included = 1 and inventory > 0 and price > 0 and (title like '%".$term."%') and category = '".$category."'"; } $resultcount = $db->query($totalcountsql); $countrow = mysqli_fetch_row($resultcount); $count = $countrow[0]; $result = $db->query($sql); $numofpages = ceil($count/$num); if ($count == 0) { ?>