aaaa, ok, sorry for the disturbance. greets.

Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS


----- Original Message ----- 
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; "Rick Emery" <[EMAIL PROTECTED]>
Sent: Tuesday, September 11, 2001 4:39 PM
Subject: RE: [PHP-DB] reading arrays within a field from mysql and separating the 
values


> yes, is corrrect concerning implode(), which constructs a string from an
> array.  He already has string, such as "name1,name2,name3,name4".  What he
> wants is:
>  $array[0] = "name1"
>  $array[1] = "name2"
>  $array[2] = "name3"
>  $array[3] = "name4"
> 
>  $array = explode(",", "name1,name2,name3,name4" )     performs this
> function
> 
> -----Original Message-----
> From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 11, 2001 8:32 AM
> To: Rick Emery
> Subject: Re: [PHP-DB] reading arrays within a field from mysql and
> separating the values
> 
> 
> so implode(' ') separates the values with <space>. i use implode() many
> times when using files. $content =
> implode('',file('file_name'));
> 
> Andrey Hristov
> IcyGEN Corporation
> http://www.icygen.com
> BALANCED SOLUTIONS
> 
> 
> ----- Original Message -----
> From: "Rick Emery" <[EMAIL PROTECTED]>
> To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, September 11, 2001 4:30 PM
> Subject: RE: [PHP-DB] reading arrays within a field from mysql and
> separating the values
> 
> 
> > Andrey,
> >
> > He wants to separate values from an array, not combine them into an array.
> >
> > -----Original Message-----
> > From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 11, 2001 8:26 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] reading arrays within a field from mysql and
> > separating the values
> >
> >
> > $my_arr= array(.....);
> > echo implode(' ',array_keys($my_arr));
> >
> > Andrey Hristov
> > IcyGEN Corporation
> > http://www.icygen.com
> > BALANCED SOLUTIONS
> >
> >
> > ----- Original Message -----
> > From: "Rick Emery" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, September 11, 2001 4:23 PM
> > Subject: RE: [PHP-DB] reading arrays within a field from mysql and
> > separating the values
> >
> >
> > > the explode() should have worked on that.  Something like:
> > >
> > > $query = "SELECT DCD_Access FROM userdb WHERE ID = $user_ID";
> > > $result4 = mysql_query($query) or die("Error");
> > > $DCD = mysql_fetch_array($result4);
> > > $myarray = explode( ",", $DCD['DCD_Access'] );
> > > foreach ( $myarray as $val )
> > >       {
> > >         print "<option value='$val'>$val</option>\n";
> > >       }
> > >
> > > -----Original Message-----
> > > From: Robert Trembath [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 10, 2001 4:45 PM
> > > To: Rick Emery
> > > Subject: Re: [PHP-DB] reading arrays within a field from mysql and
> > > separating the values
> > >
> > >
> > > NASA, BBCI
> > >
> > > I want to separate these but I either get what I show above as a single
> > > value or the word "Array" depending on how I try to get to the values.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Rick Emery" <[EMAIL PROTECTED]>
> > > Newsgroups: php.db
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Monday, September 10, 2001 4:27 PM
> > > Subject: RE: [PHP-DB] reading arrays within a field from mysql and
> > > separating the values
> > >
> > >
> > > > Robert,
> > > >
> > > > Do a manual "SELECT DCD_Access FROM userdb WHERE ID = ### "
> > > > and send the results.  I'd like to see exactly what is in that field.
> > The
> > > > explode() should have provided an array of values
> > > >
> > > > rick
> > > >
> > > > -----Original Message-----
> > > > From: Robert Trembath [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, September 10, 2001 3:53 PM
> > > > To: Rick Emery
> > > > Subject: Re: [PHP-DB] reading arrays within a field from mysql and
> > > > separating the values
> > > >
> > > >
> > > > The same as my original message.
> > > >
> > > > ----- Original Message -----
> > > > From: "Rick Emery" <[EMAIL PROTECTED]>
> > > > Newsgroups: php.db
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Monday, September 10, 2001 3:40 PM
> > > > Subject: RE: [PHP-DB] reading arrays within a field from mysql and
> > > > separating the values
> > > >
> > > >
> > > > > 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]
> > >
> > >
> >
> >
> > --
> > 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]

Reply via email to