Re: DB Question | A hotel reservation scenario
| From: | Bastien Koert | Date: | Tue, 18 Aug 2009 14:53:54 +0000 |
| Subject: | Re: DB Question | A hotel reservation scenario | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296925@lists.php.net to get a copy of this message | ||
On Tue, Aug 18, 2009 at 10:45 AM, Behzad<behzad.eslami@gmail.com> wrote:
> 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
>
query using the BUSY status as a parameter? But really you haven't
given enough to ascertain whether the structure is set to allow this
to happen
--
Bastien
Cat, the other other white meat