$checkTime = mysql_query("SELECT id FROM fm_calendar_resourceRequests WHERE ((`startDate` BETWEEN '".date("Y-m-d", strtotime($firstDay))."' AND '".date("Y-m-d", strtotime($returnDay))."') OR (`endDate` BETWEEN '".date("Y-m-d", strtotime($firstDay))."' AND '".date("Y-m-d", strtotime($returnDay))."')) AND ((`startTime` BETWEEN '".$startTime."' AND '".$endTime."') OR (`endTime` BETWEEN '".$startTime."' AND '".$endTime."'))") or die("Check Times: " . mysql_error());
SELECT id FROM fm_calendar_resourceRequests WHERE ((`startDate` BETWEEN '2013-06-27' AND '2013-06-27') OR (`endDate` BETWEEN '2013-06-27' AND '2013-06-27')) AND ((`startTime` BETWEEN '10:00' AND '12:30') OR (`endTime` BETWEEN '10:00' AND '12:30'))
SELECT id
FROM fm_calendar_resourceRequests
WHERE
(
(
(`startDate` BETWEEN '2013-06-27' AND '2013-06-27')
OR
(`endDate` BETWEEN '2013-06-27' AND '2013-06-27')
)
AND
(
(`startTime` BETWEEN '10:00' AND '12:30')
OR
(`endTime` BETWEEN '10:00' AND '12:30')
)
)
OR
(
(`startDate` <= '2013-06-27' AND `startTime` <= '10:00')
AND
(`endDate` >= '2013-06-27' AND `endTime` >= '12:30')
)
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
Open in new window
HTH, ~Ray