Page 1 of 1

how to make a reservation

Posted: Sat Jan 24, 2009 1:12 pm
by m2babaey
Hi
I plan to code a reserving system for say a hotel
I'm thinking about a good database structure and querying
1 solution is:
if i want to reserve a room from July 15th for 5 days I query the database in a for loop for the days 15th, 16th until 20 of July in a table with reserved days ( i may have to count the number of results to compare with my capacity of people ect)
what suggestions or experiences do you have
thanks for your help

Re: how to make a reservation

Posted: Sat Jan 24, 2009 2:14 pm
by Mark Baker
m2babaey wrote:if i want to reserve a room from July 15th for 5 days I query the database in a for loop for the days 15th, 16th until 20 of July in a table with reserved days ( i may have to count the number of results to compare with my capacity of people ect)
Surely better to work out the date of the last night as first night + days, and then look for a room that was not booked between those dates.