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) { ?>

Sorry No Results Found

Page of
Show Results per page
Page of
Show Results per page

Continue to Amazon.com to add this item to your cart or complete your purchase.

Continue to Amazon Buy from Amazon

Return to this window to continue shopping for American-made products on MadeInTheUSA.com.

×
close(); ?>