mySQL SET type ---pls help!

[phpwannabe]

Hello. I have a table with a SET type field. I have an update page for users to update their current selections. When I display this update page, I would like to reflect the current values in the SET type field as 'selected' on the update page, so the user can see the current selections and make changes accordingly. I'm currently using a list box, but that's not absolutely necessary. They can be displayed any way, as long as I can see what's selected and what's not. Your help is greatly appreciated!! Thanks.

[amansabharwal]

HI

you can use multiple select box and put the option in to loop

as given below:

<select name="xyz">

<?php
$options= ("a","b","c","d")  ;

for(i=0; i<sizeof(options);$i++)
{
    if(inarray($options[$i], $database))
          echo "<option value=".$options[$i]."  selected>".$options[$i]."</option>";
else   echo "<option value=".$options[$i]." >".$options[$i]."</option>";

}


?>
</select>

Please note that $database is an array which contains the set of values which are in database.