Alright Guys

I have created a page called specials... see here http://www.digitalresellersvault.com/member/special.php

You can get to it by clicking on the Dollar Deals link on the left hand side..

What it is suppose to do is show the products under the specials category.. can you help please?

Code:
<?php
include_once ("header.php");
$cat = $_GET["cat"];
$link = $_GET["category"];
$search = $_GET["search"];
$cat_title = str_replace("_"," ",$link);

if($cat != "t")
	{
	$GetFile = file("http://www.digitalresellersvault.com/template/template.php");
	$Content = join("", $GetFile);
	$categories=$common->categories($db);
	$content=str_replace("{categories}",$categories,$content);	
	$Pat = "/<{Begin}>(.*?)<{End}>/s";
	preg_match($Pat,$Content,$Output);
	$SelectedContent = $Output[1];
	$q = "select *,DATE_FORMAT(product_date, '%m-%d-%Y') as date from
	".$prefix."products where show_product = '1' ORDER BY Rand() LIMIT 1";
	
	$r = $db->get_a_line($q);
	$id = $r[id];
	$imageurl = $r[imageurl];
	$prod_description = $r[prod_description];
	$salesprice = $r[price];
	$product_name = $r[product_name];
	$salespage_link='<a href="prods.php?pid='.$id.'">Click Here For More Information</a>';
	$product_name='<a href="prods.php?pid='.$id.'">'.$product_name.'</a>';			
	$prod_image='<a href="prods.php?pid='.$id.'"><img src="images/'.$imageurl.'"></a>';		
	$Content = preg_replace($Pat,$ToReplace,$Content);
	$Content = preg_replace("/{{(.*?)}}/e", "$$1", $Content);
	echo $Content;
	include_once ("footer.php");		
	exit();		
	}


elseif($cat == "t")
	{
	$search = $_GET["search"];
	$link = $_GET["category"];
	$cat_title = str_replace("_"," ",$link);
	$GetFile = file("http://www.digitalresellersvault.com/template/template.php");
	$Content = join("", $GetFile);
	$categories=$common->categories($db);
	$content=str_replace("{categories}",$categories,$content);	
	$theselect=$common->category_select($db, 'select');
	$Content = str_replace("{{category_select}}", $theselect, $Content);
	$Pat = "/<{Begin}>(.*?)<{End}>/s";
	preg_match($Pat,$Content,$Output);
	$SelectedContent = $Output[1];
	
	if($search_txt != "")
		{
		$cond	= "where product_name like '%".$search_txt."%' && show_product = '1'";		
		}
	else
		{
		$cond	= "where category = '$cat_title' && show_product = '1'";
		}

	########## pagination ###########
	$q = "select count(*) as cnt from ".$prefix."products $cond";
	$r = $db->get_a_line($q);
	$count = $r[cnt];
	if($count == "0")
		{
		$warning = "No Results Found";
		}
	$records=10;
	$links="marketplace.php?cat=t&category=$category&search_txt=$search_txt&";
	if($page=="")
		{
		$page=1;
		}
	$start=($page-1)*$records;
	$Content=$common->print_page_break3($db,$Content,$count,$records,$links,$page);
	########## pagination ###########

	$ChangeColor = 1;
	$ToReplace = "";
	$GetProduct = $db->get_rsltset("select *,(SELECT
DATE_FORMAT(product_date, '%b/%d/%Y')) as formatteddate from
".$prefix."products $cond order by product_date DESC limit $start, $records");
	for($i = 0; $i < count($GetProduct); $i++)
		{
		$bgcolor = "#FFFFFF";
		@extract($GetProduct[$i]);
		if($period3_interval == "D"){$interval = "Day(s)";}
		if($period3_interval == "W"){$interval = "Week(s)";}
		if($period3_interval == "M"){$interval = "Month(s)";}
		if($period3_interval == "Y"){$interval = "Year(s)";}
		
		
		$product_name='<a href="prods.php?pid='.$id.'">'.$product_name.'</a>';
		

		if($subscription_active == "1")
			{
			$salesprice = $amount3." every ".$period3_value." ".$interval;
			}
		else
			{
			$salesprice = $price;
			}	
		$prod_image='<a href="prods.php?pid='.$id.'"><img src="images/'.$imageurl.'"></a>';	
		$download_link='<a href="http://www.digitalresellersvault.com/go/downloads/'.$download_link.'"><img border="0" src="http://www.digitalresellersvault.com/template/images/downloadbutton.jpg" width="104" height="16"></a>';

		$salespage_link='<a href="prods.php?pid='.$id.'"><img border="0" src="http://www.digitalresellersvault.com/template/images/moreinfobutton.jpg" width="104" height="16"></a>';
		$ToReplace .= preg_replace($Ptn,"$$1",$SelectedContent);
		}
	}	
		
$Content = preg_replace($Pat,$ToReplace,$Content);
$Content = preg_replace("/{{(.*?)}}/e", "$$1", $Content);
echo $Content;
include_once ("footer.php");
?>