If 2 weeks old

[Mutley]

Hi,

 

Trying to write a script, when someone adds a product to the database it automatically puts the date into a field in the database (DATE 0000-00-00) of the current date.

 

What I want to do is IF the product was submitted within the last 2 weeks to display an image. A "new product" style image. If it's older don't display anything.

 

How would I do this?

[skali]

Use MySQL DATEDIFF(expr1,expr2) function:

 

DATEDIFF() returns expr1 – expr2 expressed as a value in days from one date to the other. expr1 and expr2 are date or date-and-time expressions.

 

[Barand]

or

 

$sql = "SELECT prod_id, prod_name, 
        IF(prod_date > CURDATE() - INTERVAL 14 DAY, 'Y', 'N') AS newprod
        FROM products";

 

Then output the "new image" when $row['newprod'] == 'Y'