|
Suggested
Links
|
$dbh=mysql_pconnect ("localhost", "awh_unlinks", "pwlinks");
mysql_select_db ("awh_links");
$sql = mysql_query("select count(*) FROM links_items WHERE prodLinknumber like '%2%' and prodActive like '%Yes%' and prodCatone like '%Apparel%' and prodCattwo like '%Uniform%' and prodCatthree like '%Scrubs%'");
$products = mysql_fetch_array($sql);
$pageNo = ($items / 12 + 1);
$next = ($items + 12); ?>
echo "Page " . $pageNo . " of " . ceil($products[0] / 12) ?>
|