How do you output SET?

[Spanito]

Anyone know how to output a SET from mysql database to a html page so it looks like a drop down menu?

Example: SET('Green','Yellow','Red') <---- in database

how do you output in a html or PHP page so a user can select it in a form?

Thank you,
Spanito

[Spanito]

Apparently I took my C programming and tried it out with PHP...
and it works,,, it may not be the correct procedure.... but what the heck ... it works.

Here it is: (I had my output information in a table by the way)

<td width="100" height="60"><font face="Arial, Helvetica, sans-serif">Colours
<?
$clrs = explode(",", $colours);
?>
<select name="select">
<?
$a=0;
while($clrs[$a] != NULL)
{
?>
<option value="<? echo $clrs[$a] ?>"> <? echo $clrs[$a]; ?></option>

<?
$a++;
}
?>
</select>

</font></td>