what do you mean by it made no difference? Did you examine each element in
$myarray? What were the results?
rick
FYI...I tried to send directly to you and the message was bounced back
-----Original Message-----
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:30 PM
To: Rick Emery
Subject: Re: [PHP-DB] reading arrays within a field from mysql and
separating the values
Rick,
I tried it and it made no difference. Could you give me a more complete
example?
Thanks for the help.
Robert
----- Original Message -----
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Robert Trembath'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 10, 2001 3:03 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and
separating the values
> $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]
>
>
>
--
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]
