Add a sticker for featured products

[hengxi]

Hello,

I have find this code for put a sticker on the news products. This work fine but i want to have the same system for the featured products.

I am 0 in PHP ; this is the code:

<?php
$datesql = "select products_date_added from products where products_id = ". (int)$_GET['products_id'] ." ";
$date_display = $db->Execute($datesql);
$newdate = $date_display->fields['products_date_added'];
$newdate2 = $newdate–30;
function reformatDate($newdate) {
list($day, $month, $year, $hour, $min, $sec) = split( '[: -]',
$newdate);
return "$day-$month-$year";
}
$dateA=$newdate;
$theDate=reformatDate($dateA);
$thirty_days_ago = mktime()-2592000;
if ($theDate >= date('d-m-Y', $thirty_days_ago)) { echo '<div class="new"></div>'; }
?>

Can you help me ? Thank you.

[hengxi]

I have find the solution and you can use if you want to put a sticker on featured products:

1°) in the stylesheet css, add a class:

.new {
background-image:url(../images/stickers.png );

width: 232px;
height: 40px;

}

2°) In the tpl_product_info_display.php, add this where you want the sticker (You must to find the good place):

<?php
$base= "select products_id from products where products_id = ". (int)$_GET['products_id'] ." ";
$base2 = $db->Execute($base);
$base3 = $base2->fields['products_id'];

$base4= "select products_id from featured where products_id = '$base3' ";

$base5 = $db->Execute($base4);
$base6 = $base5->fields['products_id'];

if ($base3=$base6){ echo '<div class="new"></div>'; }
?>

It's all

After this, all your's featured products have a sticker.