Good questions, I need to talk to the client to determine the exact
requirements and
specifications. Thank you every one for helping me to figure out the
potential db-scheme
and for opening my view with your answers :)
On Wed, Aug 19, 2009 at 10:39 PM, Bob McConnell r...@cbord.com wrote:
From:
At 2:46 PM -0400 8/18/09, Floyd Resler wrote:
I would create a room history table that contained three fields:
room number, status, date stamp. Each time the status of a room
changes insert a new record into the table with the current status
and date/time.
Take care,
Floyd
That's the way
From: Ashley Sheridan
On Tue, 2009-08-18 at 19:15 +0430, Behzad wrote:
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
On Tue, 2009-08-18 at 19:15 +0430, Behzad 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
On Tue, Aug 18, 2009 at 10:45 AM, Behzadbehzad.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
-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,
e-Greetings!
I'm faced with an interesting and challenging problem.
Consider a database,
I would create a room history table that contained three fields: room
number, status, date stamp. Each time the status of a room changes
insert a new record into the table with the current status and date/
time.
Take care,
Floyd
On Aug 18, 2009, at 10:45 AM, Behzad wrote:
Dear list,
7 matches
Mail list logo
