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

[Rick Emery]

$myarray=explode(",",$DCD['DCD_Access']);

Then, cycle through each $myarray element as you've done below.

-----Original Message-----
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 2:55 PM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]