i have an event reservation system. i need to make sure that every time someone is booking a new time, it's not overlap another reservation.
for example lets say i have an event reserved starting at X and ending at Y
X = Wed Sep 10 2014 07:30:00 GMT+0000 Y = Wed Sep 10 2014 08:00:00 GMT+0000
and now im reserving a new event
start = Wed Sep 10 2014 09:30:00 GMT+0000 end = Wed Sep 10 2014 09:30:00 GMT+0000
how can i check if they are not crushing?
lets say the first event starts at 12:00 and end 14:00,
i need to make sure that the new event is not held between these hours.
it need to be started and end before 12:00 or after 14:00.
thanks in advance!