RE: [PHP] DB Question | A hotel reservation scenario
| From: | Arno Kuhl | Date: | Tue, 18 Aug 2009 15:21:43 +0000 |
| Subject: | RE: [PHP] DB Question | A hotel reservation scenario | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296929@lists.php.net to get a copy of this message | ||
-----Original Message-----
From: Behzad [mailto:behzad.eslami@gmail.com]
Sent: 18 August 2009 04:46 PM
To: PHP General Mailing List
Subject: [PHP] DB Question | A hotel reservation scenario
Dear list,
e-Greetings!
I'm faced with an interesting and challenging problem.
Consider a database, designed for a hotel.
At any given time, each room has a different status: It's Busy or Reserved,
or Free.
It's easy to retrieve number of Free rooms at the current time.
But how can I count the number of rooms that were busy during the last week
?
I would appreciate if you take a brief moment of your time and share your
opinion.
Thank you in advance,
-b
---------
You get that information from the history table. I presume there is some
sort of a history table?
Cheers
Arno