Booking by Date/Time in mySQL

I'm facing this problem. I have made a room booking application. There is a Start Date & Time and End Date & Time of Booking a room. Problem is that once booked, you can't book a room with a date or time that falls between an Already booked Date & Time. For example, if someone's booked a room from 3rd March to 10th March between 4:00 p.m. to 12:00 p.m. , you can't book the same room for the any date between 3rd March to 10th March and between 4 pm & 12 pm. How do i do that? Regards, T. Edison jr. ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastech@yahoo.com Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/