Untitled

<?php
$page_title = "$site_name - Books & Videos";
$product_table .= "<table border=\"0\" cellpadding=\"4\" cellspacing=\"0\" class=\"black_font_1\" style=\"border: thin black solid;\" width=\"700\" align=\"left\">";

$dbx = Connect_DB('benkat_products');
$allquery = mysql_query("SELECT DISTINCT `sub_group` FROM `products` WHERE `product_group` = 'BOOKS_AND_DVDS'");
$product_table .= "  <tr>";
$product_table .= "    <td colspan=\"3\" valign=\"top\" align=\"left\">";
$product_table .= "      <span class=\"blue_font_5_bold\">";
$pre_product .= "        <a class=\"general\" href=\"/product_group.php?gid=dvds\">All</a> -";
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 .= "        <a class=\"general\" href=\"/product_group.php?gid=dvds&show=".strtolower($allresult[sub_group])."\">$sub_group</a> -";
}
$product_table .= "        ".substr($pre_product, 0, -2);
$product_table .= "    </td>";
$product_table .= "  </tr>";
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 .= "  <tr>";
        $product_table .= "    <th valign=\"top\" align=\"left\" bgcolor=\"#272074\" class=\"white_font_3\" colspan=\"2\">$sub_group</th>";
        $product_table .= "    <th valign=\"top\" align=\"left\" bgcolor=\"#272074\" class=\"white_font_3\" width=\"52\">Price</th>";
        $product_table .= "  </tr>";
        $productquery = "SELECT * FROM `products` WHERE `sub_group` = '$allresult[sub_group]' ORDER BY `product_name` ASC";
//      echo $productquery."<br>";
        $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 = "<img src=\"/products/$productresult[pid]/images/$productresult[pid]_thumb_gray.jpg\" border=\"0\">"; $x = 0; }
                        else { $bgcolor = ""; $product_thumb = "<img src=\"/products/$productresult[pid]/images/$productresult[pid]_thumb_white.jpg\" border=\"0\">"; $x++; }
       						$product_table .= "  <tr>";
						$product_table .= "    <td bgcolor=\"$bgcolor\" rowspan=\"2\" align=\"center\">";
						$product_table .= "      <a class=\"general\" href=\"/product.php?pid=$productresult[pid]\">";
						$product_table .= "        $product_thumb";
						$product_table .= "      </a>";
						$product_table .= "    </td>";
						$product_table .= "    <td bgcolor=\"$bgcolor\" valign=\"top\" class=\"black_font_1\">";
						$product_table .= "      <a class=\"general\" href=\"/product.php?pid=$productresult[pid]\" style=\"text-decoration: none;\">";
						$product_table .= "        <b  class=\"black_font_2\">$productresult[product_name]</b><br><br>";
						$product_table .= "      </a>";
						$product_table .= "      $productresult[product_simple_desc]<br><br>";
						$product_table .= "    </td>";
						$product_table .= "    <td bgcolor=\"$bgcolor\" valign=\"top\" class=\"black_font_2\"  rowspan=\"2\">";
						$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 .= "<span style=\"font-size: 10px;\">20% Off!</span><br><span style=\"text-decoration: line-through\">$$productresult[mainprice]</span><br><strong>$$product_price</strong><br><a class=\"general\" href=\"/product.php?pid=$productresult[pid]\" style=\"text-decoration: none;\"><b class=\"red_font_1_bold\">Buy Now</b></a>";
} else {
	$product_table .= " $$productresult[main_price]<br><a class=\"general\" href=\"/product.php?pid=$productresult[pid]\" style=\"text-decoration: none;\"><b class=\"red_font_1_bold\">Buy Now</b></a>";
}
						
						
						$product_table .= "    </td>";
						$product_table .= "  </tr>";
						$product_table .= "  <tr>";
						$product_table .= "    <td bgcolor=\"$bgcolor\" valign=\"top\" class=\"black_font_1\">";
						$product_table .= "      <span style=\"vertical-align: bottom; float: right;\">[<a class=\"general\" href=\"/product.php?pid=$productresult[pid]\" style=\"text-decoration: none;\"><b class=\"blue_font_1_bold\">More Info</b></a>]</span>";
						$product_table .= "    </td>";
						$product_table .= "  </tr>";
         }
        }
}
$product_table .= "</table>";

// Show all
        echo ("
        $product_table
        ");
?>