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 ?