lunartbh99 Posted February 7, 2011 Share Posted February 7, 2011 Hi i have made a search system that searches between to dates. But as you will see it doesn't show all the values. My search is mainly looking at this part of the database: startdate ---> 0000-00-00 length-----> 7/10/14 Where start date is the start of the stored holiday and length is the length of the holiday. Now with my search form you can enter to dates which are $start and $end, i want it to find holidays going on between these dates. currently i have (last part of query) AND cem.`startdate` BETWEEN "' . $start .'" AND "' . $end . '"'; This is great and works but it only shows the holidays if the start date is within the range supplied. The problem i have is that is if i search for a holiday the day after the startdate, nothing shows yet, that holiday would still be going on, based on the length! Anyone got any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/226975-date-search-query/ Share on other sites More sharing options...
fenway Posted February 13, 2011 Share Posted February 13, 2011 Then your logic is backwards -- there's an overlap somewhere. Quote Link to comment https://forums.phpfreaks.com/topic/226975-date-search-query/#findComment-1173587 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.