exploding + printing elements

[mduran]

Hello, Let's see if I can explain my problem properly.

On a MySQL db I have a field that can contain more than one item separated by a comma: "yellow,green,brown"

and a second field with one: "chairs". There might be other fields just containing "brown" or "yellow,green" etc.

I would like to print a table with in the first column one colour at a time and in the second the corresponding furniture:

yellow chairs
green chairs
brown chairs
...

and I would like to store all this information in a variable. How can I do this ? I know it's probably a combination of a query + using somewhere an explode() and printing an array, but as I say, my php knowledge is still quite 'green', so I would appreciate a code snippet.

Anyone can help me ? thanks a million.

[kelkar_mandar]

Assuming that ur bd query o/p is

first row - 1st col green,red,brown 2nd col chair
second row - 1st col red 2nd col chair

all u do is $res = mysql_query($query);
while ($results = mysql_fetch_array($res)){
$colarr = explode(',',$results['col1']);
foreach ($colarr as $vals){
echo "<tr><td>$vals</td><td>".$results[$col2]."</td></tr>";
}
}

Hope this works

[mduran]

It works nicely ! thanks !!. .. but how can I print the output ordered by the first column ? now I get something like

yellow chairs
brown chairs
red chairs
yellow chairs
red chairs

and I would like

yellow
yellow
yellow
red
red

and so on.

thanks !