Pre-select drop down choice from MySQL

Anon

Does anyone know how to pre-select a drop down list from a MySQL DB?

For example if a user has allready inputed his details and then wants to change them later on.

So field one contains a drop down choice of option 1, option 2, option3. He has previously selected Option two , but now wants to change this. I need to be able to display this dropdown with the choice of Option two allready selected.

How is this done in PHP?

Many thanks,

Stefan

Anon

<option selected> $variable </option>
<option> ... </option> ...

So all you need to do is set it up so that the users info is the initally selected, which is just plain javascript form rubbish. Where the other variables he has to choose from dont equal the initially selected one you write it... if ($nextoption != $variable){ echo "$option"; } ) in a loop ofcourse

so the option isnt printed twice, now i am just new at this stuff so if its way off then dont blame me too much

tubedogg

$userchoice = 'Option 2';

$results = mysql_query('SELECT * FROM options');

echo '<select name="name">\n';

while ($result = mysql_fetch_array($results)) {

if ($userchoice == $result['value']) {
$selected = ' selected="selected"';
} else {
// if we don't do this, every option after this one will be selected
$selected = '';
}
echo "<option value=\"" . $result['value'] . "\" $selected>" . $result['optionname'] . "</option>\n";

}

Basically you build the option drop-down, checking each time to see if the current value matches the user's previous selection. Instead of hardcoding it at the top, obviously you'd pull it from the database or wherever you're storing it.