explode()

[OwenTheSamoan]

I'm trying to use explode() with a result that is
stored in my database.

If I do something like this:

$str_text = 'blue, orange, green, red'; 
$arr_words = explode(',',$str_text); 
print_r($arr_words); 

I get the proper result which is--

Array ( [0] => blue [1] => orange [2] => green [3] => red )

but what I want to do is get the array value
from a field in my database which holds
the above color values and then explode the array values in the same way. This is what I am doing, but it doesn't work. Where am I going wrong?

<?PHP

$result = mysql_query("select * from table where color = '$color'") or die (mysql_error());

while($a_row=mysql_fetch_assoc($result)) {

$str_text = '$a_row["color"]';  
$arr_words = explode(',',$str_text); 
print_r($arr_words); 

}
?>

[Tewl]

In your while loop you only get 1 rows result at a time

while($a_row=mysql_fetch_assoc($result)) {

$str_text = '$a_row["color"]';
$arr_words = explode(',',$str_text);
print_r($arr_words);
}

e.g.

$a_row["color"]

in the loop would only return the color for that row for the colors for the entire column. Also they are not sparated by comas in the db

[OwenTheSamoan]

actually there is a comma that seperates them becuase I used this implode command to store them all under the field of "color"

'".implode(',', $color)."'

This is hoiw they actually look in the database under "color"
blue, orange, green, red

If I use a simple select statement I can get them to
print out the way they are stored "blue, orange, green, red"

but I want to use explode to break them up.

[Tewl]

hm im not sure id have to test it myself. You might wanna echoin ur results without usin the explode to see if what your results from that are. Thats about all the help i can offer with what i know sorry i cant help more.

[OwenTheSamoan]

I have echoed the results and I get the whole array. That's why I want to use explode to bring it up. Thanks anyway