how to make a reservation
Posted: Sat Jan 24, 2009 1:12 pm
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
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