spires Posted June 24, 2009 Share Posted June 24, 2009 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 Link to comment https://forums.phpfreaks.com/topic/163496-solved-selecting-the-last-7-days-help-please/ Share on other sites More sharing options...
Ken2k7 Posted June 24, 2009 Share Posted June 24, 2009 Store date in a date type format. One more thing, use Google - http://dev.mysql.com/doc/refman/5.0/en/datetime.html Link to comment https://forums.phpfreaks.com/topic/163496-solved-selecting-the-last-7-days-help-please/#findComment-862649 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.