0) { // Get current feature item click count $sql = "SELECT viewed FROM store_features WHERE ID = '$featureID'"; $temp = mysql_query($sql); $row = mysql_fetch_array($temp); $viewed = $row["viewed"] + 1; mysql_free_result($temp); mysql_query("UPDATE store_features SET viewed = '$viewed' WHERE ID = '$featureID'"); } // get the selected category name. if none then the first one $catID = mysqlquerycleaner($_REQUEST["catID"]); if($catID > 0) { $sql = "SELECT ID,category FROM store_categories WHERE ID = '$catID' AND viewable = 'Y'"; $temp = mysql_query($sql); $row = mysql_fetch_array($temp); $catID = $row["ID"]; $catname = $row["category"] . ": "; mysql_free_result($temp); } else { $catID = 0; } // get the selected category's subcategory name. if none then the first one $subID = mysqlquerycleaner($_REQUEST["subID"]); if($subID > 0) { $sql = "SELECT ID, subcategory FROM store_subcategories WHERE ID = '$subID' AND viewable = 'Y'"; $temp = mysql_query($sql); $row = mysql_fetch_array($temp); $subID = $row["ID"]; $subname = $row["subcategory"] . ": "; mysql_free_result($temp); } else { $subID = 0; } // Get item information $itemID = mysqlquerycleaner($_REQUEST["itemID"]); $sql = "SELECT * FROM store_data WHERE ID = '$itemID' AND viewable = 'Y'"; $temp = mysql_query($sql); $row = mysql_fetch_array($temp); $itemID = $row["ID"]; $title = $row["title"]; $description = $row["description"]; $forsale = $row["forsale"]; mysql_free_result($temp); ?>

ONLINE STORE

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

0) { ?>

Item Price Options
Qty Item Price
N/A $".$price." ". $uom." SALE: $".$saleprice." ".$uom.""; } ?> '.$oos.''); $i--; $num_prices--; } ?>