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 database, desig

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] 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
Normally, you'll create the databases within the native database environment. For instance, for mysql, at the mysql command line. Then, you use PHP/PERL/C/sh/bash/... to access the database with various queries, such as SELECT. You also use the database native environment to update/maintain tab

[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