Re: [PHP-DB] Populating multi-select list from mysql
On Friday 21 June 2002 10:31, bob wrote: Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = SELECT category FROM categories; $result = mysql_query($sql, $connection); while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; $category_list .= $category; } ? Here your $category_list will be a string like 'Category1Category2...', which is probably not what you want. select name=category_list_array[] multiple size=10 ? for ($i=0; $icount($category_list); $i++) { ? option value=?=$category_list[$i]??=$category_list[$i]?/option ?}? /select Now, if I echo $category_list to the page I can see I have the correct data, I just can't get it into the list box. I've seem to hit a wall on any different ways to try and make this work. What am I doing wrong? Instead of doing two loops (while and for) just have a single while loop, build your option value... inside the while loop. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* NOWPRINT. NOWPRINT. Clemclone, back to the shadows again. - The Firesign Theater */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Populating multi-select list from mysql
Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = SELECT category FROM categories; $result = mysql_query($sql, $connection); //Try This instead of the while statement foreach($result as $row) { echo 'OPTION VALUE=' . $row['category'] . '' . $row['category']; } echo '/select'; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; $category_list .= $category; } ? select name=category_list_array[] multiple size=10 ? for ($i=0; $icount($category_list); $i++) { ? option value=?=$category_list[$i]??=$category_list[$i]?/option ?}? /select Now, if I echo $category_list to the page I can see I have the correct data, I just can't get it into the list box. I've seem to hit a wall on any different ways to try and make this work. What am I doing wrong? Thanks. Rob. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Populating multi-select list from mysql
You're logic seems to make sense. The output (page source) you are getting would help. :-) Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:06 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating multi-select list from mysql Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = SELECT category FROM categories; $result = mysql_query($sql, $connection); //Try This instead of the while statement foreach($result as $row) { echo 'OPTION VALUE=' . $row['category'] . '' . $row['category']; } echo '/select'; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; $category_list .= $category; } ? select name=category_list_array[] multiple size=10 ? for ($i=0; $icount($category_list); $i++) { ? option value=?=$category_list[$i]??=$category_list[$i]?/option ?}? /select Now, if I echo $category_list to the page I can see I have the correct data, I just can't get it into the list box. I've seem to hit a wall on any different ways to try and make this work. What am I doing wrong? Thanks. Rob. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Populating multi-select list from mysql
Whenever you are having trouble with your PHP pages, always echo! By doing this, you can see whether or not the query is formatted correctly, whether or not the variables are containing the values you think they are. It's incredibly helpful, no matter what the situation. Martin Ryan Jameson (USA) [EMAIL PROTECTED] 06/21/02 12:10PM You're logic seems to make sense. The output (page source) you are getting would help. :-) Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:06 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating multi-select list from mysql Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = SELECT category FROM categories; $result = mysql_query($sql, $connection); //Try This instead of the while statement foreach($result as $row) { echo 'OPTION VALUE=' . $row['category'] . '' . $row['category']; } echo '/select'; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; $category_list .= $category; } ? select name=category_list_array[] multiple size=10 ? for ($i=0; $icount($category_list); $i++) { ? option value=?=$category_list[$i]??=$category_list[$i]?/option ?}? /select Now, if I echo $category_list to the page I can see I have the correct data, I just can't get it into the list box. I've seem to hit a wall on any different ways to try and make this work. What am I doing wrong? Thanks. Rob. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Populating multi-select list from mysql
Thanks for all the help. I got it working using the following code from Martin. Rob. $sql = SELECT category FROM categories; $result = mysql_query($sql, $connection); echo select name=\name here\\n; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; echo option value=\$category\$category/option\n; } echo /select\n\n; ? -Original Message- From: Martin Clifford [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 12:20 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating multi-select list from mysql Whenever you are having trouble with your PHP pages, always echo! By doing this, you can see whether or not the query is formatted correctly, whether or not the variables are containing the values you think they are. It's incredibly helpful, no matter what the situation. Martin Ryan Jameson (USA) [EMAIL PROTECTED] 06/21/02 12:10PM You're logic seems to make sense. The output (page source) you are getting would help. :-) Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:06 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating multi-select list from mysql Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = SELECT category FROM categories; $result = mysql_query($sql, $connection); //Try This instead of the while statement foreach($result as $row) { echo 'OPTION VALUE=' . $row['category'] . '' . $row['category']; } echo '/select'; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; $category_list .= $category; } ? select name=category_list_array[] multiple size=10 ? for ($i=0; $icount($category_list); $i++) { ? option value=?=$category_list[$i]??=$category_list[$i]?/option ?}? /select Now, if I echo $category_list to the page I can see I have the correct data, I just can't get it into the list box. I've seem to hit a wall on any different ways to try and make this work. What am I doing wrong? Thanks. Rob. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php