Re: reading arrays within a field from mysql and separating the values

aaaa, ok, sorry for the disturbance. greets. Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS ----- Original Message ----- From: "Rick Emery" <remery@excel.com> To: "'Andrey Hristov'" <andy@anderseen.com>; "Rick Emery" <remery@excel.com> 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:andy@anderseen.com] > 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" <remery@excel.com> > To: "'Andrey Hristov'" <ahristov@icygen.com>; > <php-db@lists.php.net> > 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:ahristov@icygen.com] > > Sent: Tuesday, September 11, 2001 8:26 AM > > To: php-db@lists.php.net > > 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" <remery@excel.com> > > To: <php-db@lists.php.net> > > 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:robert@bacbarcodes.com] > > > 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" <remery@excel.com> > > > Newsgroups: php.db > > > To: <php-db@lists.php.net> > > > 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:robert@bacbarcodes.com] > > > > 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" <remery@excel.com> > > > > Newsgroups: php.db > > > > To: <php-db@lists.php.net> > > > > 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:robert@bacbarcodes.com] > > > > > 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" <remery@excel.com> > > > > > To: "'Robert Trembath'" <robert@bacbarcodes.com>; > > <php-db@lists.php.net> > > > > > 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: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 > > > > > > > > > > > > -- > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > 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 > > > > > > > > > > > > -- > > 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 > > >