Re: [PHP] DB Question | A hotel reservation scenario

2009-08-20 Thread Behzad
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 wrote: > From: Ashley Sherida

RE: [PHP] DB Question | A hotel reservation scenario

2009-08-19 Thread Bob McConnell
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 ret

Re: [PHP] DB Question | A hotel reservation scenario

2009-08-19 Thread tedd
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 I

Re: [PHP] DB Question | A hotel reservation scenario

2009-08-18 Thread Floyd Resler
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, e-Gr

RE: [PHP] DB Question | A hotel reservation scenario

2009-08-18 Thread Arno Kuhl
-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 dat

Re: [PHP] DB Question | A hotel reservation scenario

2009-08-18 Thread Bastien Koert
On Tue, Aug 18, 2009 at 10:45 AM, 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 nu

Re: [PHP] DB Question | A hotel reservation scenario

2009-08-18 Thread Ashley Sheridan
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 retriev

[PHP] DB Question | A hotel reservation scenario

2009-08-18 Thread Behzad
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 n

[PHP] RE: [PHP-DB] Question: Putting separate form elements into an array

2004-10-17 Thread Stuart Felenstein
> > To: Stuart Felenstein; Graham Cossey; > [EMAIL PROTECTED] > > Subject: RE: [PHP-DB] Question: Putting separate > form elements into an > > array > > > > > > Changed my direction somewhat but keep getting a > parse > > error and

[PHP] RE: [PHP-DB] Question: Putting separate form elements into an array

2004-10-17 Thread Graham Cossey
ein [mailto:[EMAIL PROTECTED] > Sent: 17 October 2004 16:14 > To: Stuart Felenstein; Graham Cossey; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Question: Putting separate form elements into an > array > > > Changed my direction somewhat but keep getting a parse > error and althoug

RE: [PHP] DB Question

2002-04-02 Thread Rick Emery
ntain table structures. -Original Message- From: Martin Clifford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 7:46 AM To: [EMAIL PROTECTED] Subject: [PHP] DB Question Hello all, I've been waiting in the shadows, reading, trying to get a handle on what type of questions go

[PHP] DB Question

2002-04-02 Thread Martin Clifford
Hello all, I've been waiting in the shadows, reading, trying to get a handle on what type of questions go here. I'm hoping this one does, and that some of you guru's might be able to offer some insight. I've just started out with PHP, and want to get to know relational databases. I've seen

[PHP] Re: [PHP-DB] question ! show binary

2001-01-31 Thread James Smith
The way you have it now, ur just storing the path to the gif. from the form field, use then in the insert area use: $result = mysql_query("insert into (filename) VALUES ('$file')") James --- Yui Hiroaki <[EMAIL PROTECTED]> wrote: > HI! > > I am using PHP in mySQL. I create table in datab