[PHP-DB] Drop-down box in php

2004-04-20 Thread andy amol
hi, I would like to know how to create and populate drop down boxes in php. I want the value to be populated from database. What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity. Thanks in advance.

[PHP-DB] Drop-down box in php

2004-04-20 Thread andy amol
hi, I would like to know how to create and populate drop down boxes in php. I want the value to be populated from database. What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity. Also if you can help me with a date

Re: [PHP-DB] Drop-down box in php

2004-04-20 Thread Torsten Lange
I use html forms with select field size 1 and the option values and/or what is supposed to appear in the box. This you populate by your DB query, maybe using an array and a loop (from 0 to ..). Torsten andy amol schrieb: hi, I would like to know how to create and populate drop down boxes in

Re: [PHP-DB] Drop-down box in php

2004-04-20 Thread Andras Got
You mean html dropdown-s? print ''; $r = mysql_query("SELECT id, field1, fieldn FROM table WHERE fieldn = 'sg'"); while($RESULT = mysql_fetch_array($)) { print ''.$RESULT['fieldn']'.'; } print ''; Validating: just check the $_POST['sg'] value, against is_numeric(), then you can do a SELEC

Re: [PHP-DB] Drop-down box in php

2004-04-20 Thread W. D.
At 10:53 4/20/2004, andy amol, wrote: >hi, > >Also if you can help me with a date validation program I will be grateful. You could use a Regular Expression: http://tinyurl.com/yr6up http://www.Google.com/search?q=regular+expressions+site%3Aphp.net Start Here to Find It Fast!™ -> http://www.US-We

Re: [PHP-DB] Drop-down box in php

2004-04-20 Thread John W. Holmes
From: "andy amol" <[EMAIL PROTECTED]> >I would like to know how to create and populate drop down boxes in php. > I want the value to be populated from database. > What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrit

RE: [PHP-DB] Drop-down box in php

2004-04-20 Thread Robert Sossomon
PROTECTED] Sent: Tuesday, April 20, 2004 11:53 AM To: David Robley; [EMAIL PROTECTED] Subject: [PHP-DB] Drop-down box in php hi, I would like to know how to create and populate drop down boxes in php. I want the value to be populated from database. What I am try to do is to provide the forign

Re: [PHP-DB] Drop-down box in php

2004-04-20 Thread andy amol
hi, I am using the following code, but it is not populating my script. If you can help I would be grateful. I am using mysql as database. $typedesc"; } ?> thanks. "John W. Holmes" <[EMAIL PROTECTED]> wrote: From: "andy amol" > I would like to know how to create and populate drop

Re: [PHP-DB] Drop-down box in php

2004-04-21 Thread John W. Holmes
From: andy amol >I am using the following code, but it is not populating my script. If you can help I would be grateful. > I am using mysql as database. > $sql = "SELECT course_id FROM course"; > $sql_result = mysql_query($sql) > or die("Couldn't execute query."); > while ($row = mysql_fetc