Re: [PHP-DB] Drop-down box in php
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_fetch_array($sql_result)) { > $type = $row["course_id"]; > $typedesc =$row["dept_id"]; > $option_block .= "$typedesc"; You're using ["dept_id"], but not selecting that column in your query. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
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 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. You still have to check. Just because you provide a discreet number of options in a box doesn't mean that's really all the user can choosefrom. There are many ways to manipulate the data.That being said, just create a loop as you draw items from your database.echo ''; $sql = "SELECT name FROM products WHERE ..."; $result = query($sql); while($row = fetch_assoc($result)) { echo "{$row['name']}\n"; } echo ""; I don't know what database you're using, so query() and fetch_assoc() are generic. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢
RE: [PHP-DB] Drop-down box in php
If it is a MySWL database, the following code works great \n"; while ($view_list = mysql_fetch_array($result)) { $view_code = $view_list[choice]; $view_desc = stripslashes($view_list[description]); $viewing .= "$view_desc\n"; } $viewing .= ""; ?> Of course you'll have to change it to fit your needs, but I just have a while loop that gets the information and then dumps each line it gets out to a temp variable. On the pages that include this one is where the displaying comes out. HTH, Robert -Original Message- From: andy amol [mailto:[EMAIL 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 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 validation program I will be grateful. Thanks in advance. - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
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 integrity. You still have to check. Just because you provide a discreet number of options in a box doesn't mean that's really all the user can choose from. There are many ways to manipulate the data. That being said, just create a loop as you draw items from your database. '; $sql = "SELECT name FROM products WHERE ..."; $result = query($sql); while($row = fetch_assoc($result)) { echo "{$row['name']}\n"; } echo ""; I don't know what database you're using, so query() and fetch_assoc() are generic. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
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-Webmasters.com/best-start-page/ $8.77 Domain Names -> http://domains.us-webmasters.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
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 SELECT, to check whether the id exists. You can find some more examples, on php net manual pages andrej andy amol wrote: 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 validation program I will be grateful. Thanks in advance. - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
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 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 validation program I will be grateful. Thanks in advance. - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 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 validation program I will be grateful. Thanks in advance. - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢
[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 key value as combo box option, so that I do not have to check for referential integrity. Thanks in advance. - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢