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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.