Re: Complex select query

I am trying to book rooms in a hotel. A user searches for booking from
1st through 10th of a month, and if I already have a booking for 5th of
that month, then the user should get a message that booking is not
available.

What is the best way of doing this? One method I can think about it
checking the value of all records and if any of the fields contains a
value, the results are not displayed. However, I do not find this
method to be very efficient. Can this be done through a single query ?

I don't s'pose this is really a php issue, it'll depend on what database
you're using. Presumably whatever that is it'll give you a way to effect
"between", because you want to find any existing bookings *between* the
start and the end date that your prospect is trying to book.

It may be doable in a single query. It might depend on your table
structure of course.

Something like :- (serving suggestion)

SELECT * FROM Bookings WHERE BETWEEN(BookingDate, NewStart, NewFinish)
AND Room=theRoom;

?
Regards
Mark

.