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
how to make a reservation
Moderator: General Moderators
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: how to make a reservation
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.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)