lunartbh99

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?