MySQL Results into drop down menu

Hi,

I have a site populates a drop down menu with options, say...

Option 1
Option 2
Option 3
Option 4

If i customer is currently set to Option 3, i'd like this to be at the
top of the Drop down menu and therefore the default option.

This seems like a pretty simple thing but their doesn't seem to be a
quick fix.

Can anyone advise me on how to best deal with this?

Thanks in advance.

Ian

re: MySQL Results into drop down menu

when php is populating your options (done by a loop, i figure), you
just need an if statement to print selected="selected" for the default
option, like that:

$default ='option3';

$options[0] = 'option0';
$options[1] = 'option1';
$options[2] = 'option2';
$options[3] = 'option3';

foreach($option as $key => $value)
{
print "<option";
if($value == $default)
{
print " selected=\"selected\"";
}
print ">".$value."</option>
}


micha

re: MySQL Results into drop down menu

Of course!

Thank you for your help