MySQL Results into drop down menu

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View


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.


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>


Re: MySQL Results into drop down menu

Of course!

Thank you for your help

Site Timeline