$area = "onlinestore";
include("../includes/header.php");
// If the item came from a feature item click through - record it
$featureID = mysqlquerycleaner($_REQUEST["featureID"]);
if($featureID > 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);
?>
|
|
|
include("../includes/footer.php");
?>