CAN Someone Please Help Me To Ger The Newest Category Displayed on This Page?

Alright guys

I am going crazy at the moment... This is now starting to do my head in. I have asked on several forums and no one can seem to answer it.. There must be way.. MUST BE!

Right firstly can you take a look at my site Untitled Document I am using a membership script called simple member pro, which I have customized myself...

I have created a new php page called newest, but as you can see nothing comes up as yet.

What I am trying to do, is when you click on the Newest Product ur link in the Navigational link section you are taken to that page. Then on that page you are suppose to see the lastest/new category that we have added to membership site..

Please can someone take a look at my membership script and help me please!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Jaan said:

Can you show us your code ? Maybe then we can help you :)

Here you go

<?php
include_once ("header.php");
$cat = $_GET["cat"];
$link = $_GET["category"];
$search = $_GET["search"];
$cat_title = str_replace("_"," ",$link);
if($cat != "t")
 {
 $GetFile = file("[URL]http://www.digitalresellersvault.com/template/template.php[/URL]");
 $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("[URL]http://www.digitalresellersvault.com/template/template.php[/URL]");
 $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="[URL="http://www.digitalresellersvault.com/go/downloads/'.$download_link.'"><img"]http://www.digitalresellersvault.com/go/downloads/'.$download_link.'"><img[/URL] border="0" src="[URL]http://www.digitalresellersvault.com/template/images/downloadbutton.jpg[/URL]" width="104" height="16"></a>';
  $salespage_link='<a href="prods.php?pid='.$id.'"><img border="0" src="[URL]http://www.digitalresellersvault.com/template/images/moreinfobutton.jpg[/URL]" 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");
?>