Pre selecting value from drop down menu with PHP/MYsql

[Wardy]

I have another php/mysql problem if anyone is able to help (I have tried to make it as clear as posisble)

I have a drop down/list menu that I have entered a number of different options a user can choose from. When they select the one they want and submit it gets saved to the database. Now I know it's easy enough to pull the chosen selection out and display it on a page but what I want to do is the next time they enter their account area that the option they chose is to be pre-selected from the drop down list for them and this is the bit I'm struggling with.

Below is a sample drop down menu and to have a pre-selected answer you need to add "selected" after the value (as in the example under this one where Option 3 is pre-selected.)

<select name="favpr">
   <option value="option1">Option 1</option>
   <option value="option2">Option 2</option>
   <option value="option3">Option 3</option>
   <option value="option4">Option 4</option>
</select>

<select name="favpr">
   <option value="option1">Option 1</option>
   <option value="option2">Option 2</option>
   <option value="option3" selected>Option 3</option>
   <option value="option4">Option 4</option>
</select>

Can anyone help becuase I'm stumped at the moment.

Cheers
Wardy

[haggul]

If you are building the choices from a database or loop it's more simple - if not it's pretty easy just not very elegant :


<option value="option1" <?php if($varfromdb=="option1"){ echo " selected"; }?>>Option 1</option>

and so on

[Northern Monkey]

I agree with haggul, that's exactly how I do it. It doesn't look very clean but it works.

NM.