";
$dbx = Connect_DB('benkat_products');
$allquery = mysql_query("SELECT DISTINCT `sub_group` FROM `products` WHERE `product_group` = 'BOOKS_AND_DVDS'");
$product_table .= " ";
$product_table .= " | ";
$product_table .= " ";
$pre_product .= " All -";
while($allresult = mysql_fetch_assoc($allquery)) {
if (strtoupper($allresult[sub_group]) == 'DVDS') { $sub_group = 'DVD\'s'; }
elseif ($allresult[sub_group] == 'BOOKS') { $sub_group = 'Books'; }
elseif ($allresult[sub_group] == 'COMBOS') { $sub_group = 'Combos'; }
else $sub_group = $allresult[sub_group];
$pre_product .= " $sub_group -";
}
$product_table .= " ".substr($pre_product, 0, -2);
$product_table .= " | ";
$product_table .= "
";
if ($_GET['show']) { $allquery = mysql_query("SELECT DISTINCT `sub_group` FROM `products` WHERE `sub_group` = '$_GET[show]'"); }
else { $allquery = mysql_query("SELECT DISTINCT `sub_group` FROM `products` WHERE `product_group` = 'BOOKS_AND_DVDS'"); }
while($allresult = mysql_fetch_assoc($allquery)) {
if (strtoupper($allresult[sub_group]) == 'DVDS') { $sub_group = 'DVD\'s'; }
elseif ($allresult[sub_group] == 'BOOKS') { $sub_group = 'Books'; }
elseif ($allresult[sub_group] == 'COMBOS') { $sub_group = 'Combos'; }
else $sub_group = $allresult[sub_group];
$product_table .= " ";
$product_table .= " | $sub_group | ";
$product_table .= " Price | ";
$product_table .= "
";
$productquery = "SELECT * FROM `products` WHERE `sub_group` = '$allresult[sub_group]' ORDER BY `product_name` ASC";
// echo $productquery."
";
$productquery = mysql_query($productquery);
$x = 0;
if (@mysql_num_rows($productquery) > 0) {
while($productresult = mysql_fetch_assoc($productquery)) {
if ($x == 1) { $bgcolor = "#F5F5F5"; $product_thumb = "![](\"/products/$productresult[pid]/images/$productresult[pid]_thumb_gray.jpg\")
"; $x = 0; }
else { $bgcolor = ""; $product_thumb = "![](\"/products/$productresult[pid]/images/$productresult[pid]_thumb_white.jpg\")
"; $x++; }
$product_table .= " ";
$product_table .= " | ";
$product_table .= " ";
$product_table .= " $product_thumb";
$product_table .= " ";
$product_table .= " | ";
$product_table .= " ";
$product_table .= " ";
$product_table .= " $productresult[product_name]
";
$product_table .= " ";
$product_table .= " $productresult[product_simple_desc]
";
$product_table .= " | ";
$product_table .= " ";
$current_date = strtotime("today");
$start_date = strtotime("November 27th, 2006");
$end_date = strtotime("December 22nd, 2006");
if($current_date > $start_date && $current_date < $end_date || $current_date == $start_date || $current_date == $end_date)
{
$product_price = ($productresult['mainprice'] * .8);
$product_table .= "20% Off!
$$productresult[mainprice]
$$product_price
Buy Now";
} else {
$product_table .= " $$productresult[main_price]
Buy Now";
}
$product_table .= " | ";
$product_table .= "
";
$product_table .= " ";
$product_table .= " | ";
$product_table .= " [More Info]";
$product_table .= " | ";
$product_table .= "
";
}
}
}
$product_table .= "";
// Show all
echo ("
$product_table
");
?>