-----Original Message-----
From: Behzad [mailto:behzad.esl...@gmail.com] 
Sent: 18 August 2009 04:46 PM
To: PHP General Mailing List
Subject: [PHP] DB Question | A hotel reservation scenario

Dear list,

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

Thank you in advance,

You get that information from the history table. I presume there is some
sort of a history table?


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

Reply via email to