|
| |
|
|
untangled
Posts: 7
From: None
Status: offline
 |
HOTEL BOOKING SYSTEM - 4/9/2001 20:12:00
I have been instructed to write a very basic hotel booking system for a Web Site. The only problem I have is with regard to room availability. In that how do I set up the database to query whether a room is available or not as it could be booked 365 times in a year and I do not want the room table to have to search 365 fields each time.Regards
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: HOTEL BOOKING SYSTEM - 4/9/2001 23:48:00
You would need to specfy "where datefield between #date1# and #date2#"
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
