Julian Posted June 11, 2007 Share Posted June 11, 2007 Hello Maybe is silly but I know I can find a solution here. I have this table id | datein | dateout 1 | 2007-05-11 | 2007-10-11 2 | 2007-06-11 | 2007-10-11 What I'm trying to do is get all the records between date I passed via form. I tried "Select * from dates WHERE datein >= '$datein' AND dateout <= '$dateout'"; I stored dates as DATE on the DB. I tried to use BETWEEN, but I don't know if I can use on two different columns. Thanks for the help guys. Quote Link to comment https://forums.phpfreaks.com/topic/55177-get-records-betwen-two-date-columns/ Share on other sites More sharing options...
Barand Posted June 11, 2007 Share Posted June 11, 2007 What was wrong with "Select * from dates WHERE datein >= '$datein' AND dateout <= '$dateout'"; Quote Link to comment https://forums.phpfreaks.com/topic/55177-get-records-betwen-two-date-columns/#findComment-272735 Share on other sites More sharing options...
Julian Posted June 11, 2007 Author Share Posted June 11, 2007 With this Select I do not get the results I want. It seems only work with year. I want to list the dates (including day and month) that are between datein and dateout only. Thanks $datein = 2007-05-12 $dateout = 2007-06-12 Quote Link to comment https://forums.phpfreaks.com/topic/55177-get-records-betwen-two-date-columns/#findComment-272739 Share on other sites More sharing options...
Barand Posted June 11, 2007 Share Posted June 11, 2007 What does this output echo "Select * from dates WHERE datein >= '$datein' AND dateout <= '$dateout'"; Quote Link to comment https://forums.phpfreaks.com/topic/55177-get-records-betwen-two-date-columns/#findComment-272741 Share on other sites More sharing options...
Julian Posted June 11, 2007 Author Share Posted June 11, 2007 Hi I get the desired records if I change the variables for the exact dates that are stored on datein and dateout. It seems that the >= or <= is not working for my purposes. Because the in between dates doesn't show up when I change the datein or dateout input, even if the dates I put are in range. Quote Link to comment https://forums.phpfreaks.com/topic/55177-get-records-betwen-two-date-columns/#findComment-272750 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.