mysql results - select list / radiobutton

[netzverwalter]

hi folks,

following problem:

i have select-lists and radio-buttons on my site:

ie:

      <select name="area_open">
        <option value="<?php echo $open ?>" selected> 
        <?php echo $open ?>
        </option>
        <option value="yes">yes</option>
        <option value="no">no</option>
      </select>

there are two (ore more) options - in this case "yes or no" - if the user changes the value in the mysql-database, the result should be, that the selected value in the database is also the selected value at the list.

but with my example, i have 3 values (yes, yes, no or no, yes, no) - but i only want 2 of them (the selected one and the other one)

hope my english is good enough!!!

thanks

[gardenhost]

Use should use a regular if/else control structure for such cases:

<select name="area_open"> 
<option value="<?php echo $open ?>" selected> 
<?php echo $open ?> 
</option> 
<?php if ($open == "yes") { 
    echo "<option value=\"yes\">yes</option>";
} else {
    echo "<option value=\"no\">no</option>";
}; ?>
</select> 

Remember to escape any double qoutes inside your string as shown.

[gardenhost]

Use should use a regular if/else control structure for such cases:

<select name="area_open"> 
<option value="<?php echo $open ?>" selected> 
<?php echo $open ?> 
</option> 
<?php if ($open == "yes") { 
    echo "<option value=\"yes\">yes</option>";
} else {
    echo "<option value=\"no\">no</option>";
}; ?>
</select> 

Remember to escape any double qoutes inside your string as shown.

[netzverwalter]

thanks for your answer.

but what should i do in case of 20 or more options - i would have to write if / else-statements for every possibility?

isn't there a nicer solution?

thanks