On Tue, Aug 18, 2009 at 10:45 AM, Behzad<behzad.eslami@xxxxxxxxx> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
