[SOLVED] Selecting the last 7 days, help please.

[spires]

Hi guys.

 

I'm trying to select all enteries from my database within the last 7 days.

 

$todaysDate = date("d/m/Y");
SELECT * FROM csv_notes 
WHERE notes_date2 >= DATE_SUB($todaysDate, INTERVAL 7 DAY)

 

The data in the data base are:

19/06/2009

20/06/2009

21/06/2009

22/06/2009

23/06/2009

 

However, it's not selecting anything?

 

Can someone please let me know what i'm doing wrong.

 

 

Thanks

 

 

[Ken2k7]

Store date in a date type format.

 

One more thing, use Google - http://dev.mysql.com/doc/refman/5.0/en/datetime.html