|
|
Posted by Pankaj on 10/26/06 08:11
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 ?
Thanks
Pankaj
Navigation:
[Reply to this message]
|