On Tue, Aug 18, 2009 at 10:45 AM, Behzad<behzad.esl...@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



Cat, the other other white meat

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to