vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi all I am designing a booking system to allow management of hotels. I need to be able to show what rooms are free on each day of the year. Obviously I have a hotel table, a room table, and a booking table. My question is how do I represent this without having a record for each room for each day of the year? I would need to run 365 queries to show the table that I want i.e. Date | Hotel | Rooms Booked | Rooms Free 1/1/03 2/1/03 3/1/03 .. .. .. or would I? Thanks to all suggestions |