dynamic list from sql table

ctsiow

Hi
What am i doing wrong here please?

I would like to put a dymanic select list on a form with the choices coming from a row of a table, table has the structure
id colour1 colour2 colour3

and I would like to give the dropdown the colour associated with the entry for each of colour 1-3 so if a line has

id=sss colour1=red colour2=black colour3=NULL

I would like the dynamic dropdown to have 2 choices, red or black but if the next row had

colour1=red colour2=black colour3=green

it picks up those values instead. The info for each id will be different, I have a table being built populated from the same table at the moment but built from different columns so I have a suitable record set already.
Thanks
Mark

NogDog

Probably a better solution would be to just have a 2-column color-to-item relation table:

id   color
===  =====
1    red
1    green
2    red
2    green
2    blue

Then you would just select all colors for the desired ID:

$query = "SELECT color FROM item_color WHERE id = $id";
$result = mysql_query($query);
echo "<select name='color'>\n";
while($row = mysql_fetch_assoc($result))
{
   echo "<option>{$row['color']}</option>\n";
}
echo "</select>\n";

ctsiow

Hey NogDog
You are right of course!:o
I got set on one idea and couldn't see the way to do it my way then went further and further away from the right way.
Thanks for putting me right.
Mark