PHP and Mysql Date Question

fluiduk · 23 Nov 2006 at 15:51

Hi All

I am trying to make a query that will recall all records from a database where an mysql date field is 7 days earlier than the current date. Ie 7 days have passed since the date in the field.

Is there a simple way to do this?

Any advice appreciated

Thanks
Aaron

fluiduk · 23 Nov 2006 at 16:27

Maybe this will help someone, but its just plain confusing me > http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

fluiduk · 23 Nov 2006 at 16:45

Because I am not as smart as you Rob

Thanks once again.. don't know what I would do without you

Thanks

fluiduk · 23 Nov 2006 at 17:08

Although it doesn't quite work

This is the code

Code:

SELECT *
FROM returns
WHERE DATE_SUB(CURDATE(), INTERVAL -3 DAY) <= date_collection_email

I have a record where the date is 2006-11-19 and it doesn't show up. If I change the -3 to just 3, it shows all records.

Any ideas?

Thanks
Aaron

fluiduk · 23 Nov 2006 at 22:37

Trying to get ones that are older than 3 days, ie 3 days or more have passed since the date in the field.

Thanks Rob

Aaron