booking

[rakuci]

Hi guys,
I have a system to for booking books online.
I have start date,end date, start_time and end_time.
I'cant figure out how to validate those fields not to book one book 2 times in same time.
For example if the book is already booked than you get message this book is already booked
Any idea?

[tsinka]

Hi,

do you use some kind of database to store the booking data (MySQL, PostrgreSQL, Oracle ...) ?

If someone wants to book a book then check if there's already a record where

(existing_start_date/time < new_end_date/time) AND (existing_end_date/time > new_start_date/time)

This should fetch all records that touch the new booking date/time.

Thomas

[rakuci]

sorry I forgot to mention it is a mysql database

[tsinka]

Ok,

how does the table structure look like ?