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 r...@cbord.com wrote: From:

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

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 retrieve number of

[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

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 retrieve number

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

2009-08-18 Thread Bastien Koert
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

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

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,

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

2004-10-17 Thread Graham Cossey
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 although I know where it is , I can't seem to figure

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

2004-10-17 Thread Stuart Felenstein
is the current situation? Iterating through the 3 arrays or inserting into MySQL? Graham -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 17 October 2004 16:14 To: Stuart Felenstein; Graham Cossey; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Question

[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

RE: [PHP] DB Question

2002-04-02 Thread Rick Emery
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 here. I'm

[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 input type="file" name="file" 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