listbox problem

[Ali_baba]

While reteriving the data from database for "modification" purpose, I have problem with reteriving the data for listbox. I don't know what to do with it. Can somebody please help me here?

while ($array = mysql_fetch_array($result))  {
echo "<select name=\"mukanahankkeessa\"><option value=\"?\" id="\?\">[Select One]</option>
                                        <option value=\"Kyll&auml;\" id=\"Yes\">Kyll&auml;</option>
                                        <option value=\"Ei\" id=\"No\">Ei</option></select>
                                        <option value=".$array['mukanahankkeessa']." selected=\"selected\">".$array['mukanahankkeessa']."</option>  </td>";

As you can see that not only I want to display the value but I want to display the value in the list as selected.

[Frederick]

echo "<select name=\"mukanahankkeessa\" size=\"1\">\n";
echo "<option value=\"?\" id=\"?\">[Select One]</option>\n";
while ($array = mysql_fetch_array($result))  { 
    echo "<option value=\"".$array['mukanahankkeessa']."\">".$array['mukanahankkeessa']."</option>\n";
}
echo "</select>\n";

[Ali_baba]

Hello Fedrick,

Thanks for your reply.

The problem in your code is that:

1. It shows only "[Select One]" and either "Kyllä" (yes) or "Ei" (no)
2. The default selected value is [Select One].

It would be great if I can have all three values in the list + the default selected value should be the one that is in database.

I tried my best to improve it but....😕