spires Posted May 23, 2007 Share Posted May 23, 2007 Hi Can any one help. I'm trying to select all of the dates from my datebase, but over a different time scale. > past > this month > next month > coming soon I need to be able to do somthing along these lines, but i'm not to sure what. SELECT * FROM listings WHERE list_date='next month' Can anyone point me in the right direction. Thanks for your help. Link to comment https://forums.phpfreaks.com/topic/52675-solved-date-questions/ Share on other sites More sharing options...
chigley Posted May 23, 2007 Share Posted May 23, 2007 Your query above looks fine to me Link to comment https://forums.phpfreaks.com/topic/52675-solved-date-questions/#findComment-260023 Share on other sites More sharing options...
paul2463 Posted May 23, 2007 Share Posted May 23, 2007 have a look <a href="http://www.phpfreaks.com/forums/index.php/topic,141758.msg604580.html#msg604580"> HERE </a> I have answered something like this before, you may be able to work something out for youself Link to comment https://forums.phpfreaks.com/topic/52675-solved-date-questions/#findComment-260031 Share on other sites More sharing options...
spires Posted May 23, 2007 Author Share Posted May 23, 2007 Thats great, I've had a look at it and i should be able to work it out from here. Thanks again. Link to comment https://forums.phpfreaks.com/topic/52675-solved-date-questions/#findComment-260040 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.