extracting date

[KryptoS]

in my table I have a field with a date. Now I only want to get the records fromt the last 7 days :

$sql = ("SELECT * FROM tbl_images WHERE datum > datesub(now(),7)");

but I think mysql doesn't know what datesub is... is it possible to do with a php syntax?

The One And Only KryptoS

 

[KryptoS]

Damn, you search 2 hours for this and then you finally post your question on tek-tips and then 2 minutes later you find the solution...

$sql = ("SELECT * FROM tbl_images WHERE datum > subdate(NOW(),Interval 7 day)");

The One And Only KryptoS

 

[towerbase]

I think MySQL knows what DATE_SUB is. This should work:

SELECT * FROM tbl_images
WHERE datum > DATE_SUB ( NOW(), INTERVAL 7 DAY )

Andrew
Hampshire, UK

 

[kupe]

Nice one, Towerbase.

 

[KarveR]

DATE_SUB also takes month and year as arguments

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.