dates in PHP .

[James Smith]

I have a list drawn from mysql ordered alphabetically. i want a "new" image to appear to ones added in the last week.

they are submitted via a form. there is a column called "dateadded" which holds the date added in a YEAR-MONTH-DAY format.

how can i do an if query which checks if this date is 1 week or less than the current date, and then displays an image if it is ?

thanks
james

[Kevin Yank]

You need to use the MySQL IF function along with the TO_DAYS function:

SELECT ..., IF((TO_DAYS(CURDATE())-TO_DAYS(datedadded)) < 7,1,0) AS is_new FROM ...

This will create a column called is_new in your set of results, which will have a value of 1 for records less than 7 days old, and 0 for other records. You can then use this value in your PHP script to indicate whether or not a "NEW" image should be displayed.

[James Smith]

thanks ! worked to good effect !

http://www.hiphopmusic.co.uk/reviews

thanks again
james