RE: [PHP-DB] reading arrays within a field from mysql and separat ing the values

$myarray=explode(",",$DCD['fieldname']); In the above, substitute "fieldname" for the name of the field which contains name1,name2,name3,name4,... Then, cycle through each $myarray element as you've done below. -----Original Message----- From: Robert Trembath [mailto:robert@bacbarcodes.com] Sent: Monday, September 10, 2001 2:55 PM To: php-db@lists.php.net Subject: [PHP-DB] reading arrays within a field from mysql and separating the values Hello everyone, Ran into a problem trying to get this to work. I have multiple names in a mysql field (DCD_Access) that contains "name1, name2, name3, name4" and I want read this information as an array so I can use these values to populate a pull-down list using a while or foreach loop. Below is the code I used, but I get the values as a single entry no matter what I try. This query brings a single result row "name1, name2, name3, name4". Here's the code: $result4 = mysql_query( "SELECT DCD_Access FROM userdb WHERE ID = '$user_ID'"); $DCD = mysql_fetch_array ( $result4 ); print " <td width='6%' valign=top>\n <div align='center'>\n <select name='LCompare'>\n <option value='none'>None</option>\n <option value='within'>Within Gel</option>\n"; foreach ( $DCD as $val ) { print "<option value='$val'>$val</option>\n"; } print " </select></div>\n </td>\n"; This returns HTML like: <td width='6%' valign=top> <div align='center'> <select name='LCompare'> <option value='none'>None</option> <option value='within'>Within Gel</option> <option value='name1, name2, name3, name4'>name1, name2, name3, name4</option> <option value='name1, name2, name3, name4'>name1, name2, name3, name4</option> <option value='name1, name2, name3, name4'>name1, name2, name3, name4</option> <option value='name1, name2, name3, name4'>name1, name2, name3, name4</option> </select> </div> </td> What I need is to get: <td width='6%' valign=top> <div align='center'> <select name='LCompare'> <option value='none'>None</option> <option value='within'>Within Gel</option> <option value='name1'>name1</option> <option value='name2'>name2</option> <option value='name3'>name3</option> <option value='name4'>name4</option> </select> </div> </td> Anyone know how to fix this? Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net