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. Quote 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 Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/52675-solved-date-questions/#findComment-260040 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.