0) { // Build result paging $perPage = 10; //records per page $maxrecords_sql = "SELECT COUNT(ID) as maxrecords FROM store_placement sp LEFT JOIN store_data sd ON sp.itemID = sd.ID WHERE sp.catID = '$catID' AND sp.subID = '$subID' AND sd.viewable = 'Y'"; $maxpages_sql = "SELECT CEILING(COUNT(ID) / ".$perPage.") AS maxpages FROM store_placement sp LEFT JOIN store_data sd ON sp.itemID = sd.ID WHERE sp.catID = '$catID' AND sp.subID = '$subID' AND sd.viewable = 'Y'"; $maxrecords_query = mysql_query($maxrecords_sql); $temp = mysql_fetch_array($maxrecords_query); $maxrecords = $temp[0]; mysql_free_result($maxrecords_query); $maxpages_query = mysql_query($maxpages_sql); $temp = mysql_fetch_array($maxpages_query); $maxpages = $temp[0]; mysql_free_result($maxpages_query); if($_REQUEST["page"] == "") { $page = 1; } else { $page = mysqlquerycleaner($_REQUEST["page"]); } ?> 0) { ?> 1) { ?>

ONLINE STORE

0) { $count = 1; while($row = mysql_fetch_array($cat)) { ?> >
0) { ?>
>

item(s) on page(s).
");} ?> ");} if($i<=$maxpages["maxpages"]-1){print("|");} } ?>
No items to display. ",$row["description"]); $len = 200; if(strlen($description) > $len) { if(substr($description,$len,1) == " ") { $description = substr($description,0,$len); } else { for($i=$len;$i<=strlen($description);$i++) { if(substr($description,$i,1) == " ") { $description = substr($description,0,$i); break; } } } $description = $description . "... [ More ]"; } // Get pricing $sql = "SELECT COUNT(ID) AS pricesTotal, MIN(price) AS priceMin, MAX(price) AS priceMax, MIN(saleprice) AS salepriceMin, MAX(saleprice) AS salepriceMax FROM store_options WHERE itemID = '$itemID' GROUP BY itemID"; $prices = mysql_query($sql); $row = mysql_fetch_array($prices); $pricesTotal = $row["pricesTotal"]; $priceMin = $row["priceMin"]; $priceMax = $row["priceMax"]; $salepriceMin = $row["salepriceMin"]; $salepriceMax = $row["salepriceMax"]; if($salepriceMin < $priceMin && $salepriceMin != 0) { $Min = $salepriceMin; } else { $Min = $priceMin; } if($salepriceMax < $Min && $salepriceMax != 0) { $Min = $salepriceMax; } if($salepriceMax > $priceMax) { $Max = $salepriceMax; } else { $Max = $priceMax; } if($Min == $Max) { $price = "$".$Min; } else { $price = "$".$Min." - ".$Max; } ?>
0 || $salepriceMax > 0) {?>

PRICE:
''")); if($featureOOS > 0) { ?>

Some items may be out of stock, click here for details.