I have a column in a table that stores the date (say, 2009-08-31 11:08:19).
Now, I'd like to do a SQL Query which would throw up TRUE if that date is either equal to, or in the past 5 days.
Does this make sense?
so if I had
id | name | date_added
1 | jake | 2009-08-31 11:08:19
and if today was 2009-09-02 then it would give me a result.
I did have something like this, but it didn't work
Any ideas where to start?PHP Code:
SELECT DISTINCT name FROM groups WHERE date_added >= (NOW()-7)