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? 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. Link to comment https://forums.phpfreaks.com/topic/226975-date-search-query/#findComment-1173587 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.