How Do I Just Get The Newest Products To Be Shown?

[byronwells]

Alright guys

I am in a little bit of confusion at the moment.. I am using a membership script called simplememberpro and have created a new php page called newest, please see here Untitled Document

What I am trying to do on that page is to get the products that I are linked to the newest category that we have added to the site.

So for example I have created a category called mar 2010 with two products in. Those will apear under the newest product link on that page.. Then when I add another category at the end of this month called apr 2010 with two products.. It will automatically change over

<?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="http://forum.codecall.net/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="http://forum.codecall.net/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");
?>