Comment - modifier le fichier php pour trouver des articles dans certaine plage de dates

<?php
if (!defined('WEB_ROOT')) {
    exit;
}

$productsPerRow = 4;
$productsPerPage = 20;

//$productList  = getProductList($catId);
$children = array_merge(array($catId), getChildCategories(NULL, $catId));
$children = ' (' . implode(', ', $children) . ')';

$sql = "SELECT pd_id, pd_name, pd_price, pd_thumbnail, pd_qty, c.cat_id, pd_date, pd_code
        FROM tbl_product pd, tbl_category c
        WHERE pd.cat_id = c.cat_id AND pd.cat_id IN $children
        ORDER BY pd_name";

$result   = dbQuery(getPagingQuery($sql, $productsPerPage));
$pagingLink = getPagingLink($sql, $productsPerPage, "c=$catId");
$numProduct = dbNumRows($result);


// the product images are arranged in a table. to make sure
// each image gets equal space set the cell width here
$columnWidth = (int)(100 / $productsPerRow);
?>

<p align="center"><font face="arial" color="red" size="2">Icon = added in last<img src="images/new1.gif" border="0">week<img src="images/new2.gif" border="0">2 weeks<img src="images/new3.gif" border="0">3 weeks<img src="images/new4.gif" border="0">4 weeks</font></p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; <?php echo $pagingLink; ?></p>



<table width="100%" border="0" cellspacing="0" cellpadding="6">


<?php
if ($numProduct > 0 ) {

    $i = 0;
    while ($row = dbFetchAssoc($result)) {
    
        extract($row);
        if ($pd_thumbnail) {
            $pd_thumbnail = $pd_thumbnail;
        } else {
            $pd_thumbnail = WEB_ROOT . 'images/no-image-small.png';
        }
    
        if ($i % $productsPerRow == 0) {
            echo '<tr valign="top">';
        }

        
        // format how we display the price
        $pd_price = displayAmount($pd_price);
        
        echo "<td width=\"$columnWidth%\" align=\"center\"><a href=\"" . $_SERVER['PHP_SELF'] . "?c=$catId&p=$pd_id" . "\"><img src=\"$pd_thumbnail\" border=\"0\"><br>$pd_name</a><br># $pd_code<br />$pd_price";

        // if the product is no longer in stock, tell the customer
        if ($pd_qty <= 0) {
            echo "<br><strong><font color='#FF0000'>Sold</font></strong>";
        }

// is product new?
       
        //$today=date("Y-m-d");
        $compareDate1=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-28,date("Y")));
        // -28 = 4 weeks
        $compareDate2=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-21,date("Y")));
        // -21 = 3 weeks
        $compareDate3=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-14,date("Y")));
        // -14 = 2 weeks
        $compareDate4=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-7,date("Y")));
        // -7 = 1 weeks

        
        // is it newer than 4 weeks?
        
        if ($pd_date > $compareDate4)
          {
          echo "<br /><img src='images/new1.gif' alt='new' /><br />";
          }
        // is it newer than 3 week?
        elseif ( $pd_date > $compareDate3)
          {echo "<br /><img src='images/new2.gif' alt='new' /><br />";
          }
        // is it newer than 2 weeks?
        elseif ($pd_date > $compareDate2)
          {echo "<br /><img src='images/new3.gif' alt='new' /><br />";
          }
        // is it newer than 1 week?
        elseif ( $pd_date > $compareDate1)
          {echo "<br /><img src='images/new4.gif' alt='new' /><br />";
          }
        
        

        
        echo "</td>\r\n";
    
        if ($i % $productsPerRow == $productsPerRow - 1) {
            echo '</tr>';
        }
        
        $i += 1;
    }
    
    if ($i % $productsPerRow > 0) {
        echo '<td colspan="' . ($productsPerRow - ($i % $productsPerRow)) . '">&nbsp;</td>';
    }
    
} else {
?>
    <tr><td width="100%" align="center" valign="center">No products in this category at the moment</td></tr>
<?php    
}    
?>
</table>
<p align="center"> <?php echo $pagingLink; ?></p><br />