MySQL Results into drop down menu

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Ian N

    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
  • micha

    #2
    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="selec ted" 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=\"sele cted\"";
    }
    print ">".$value. "</option>
    }


    micha

    Comment

    • Ian N

      #3
      Re: MySQL Results into drop down menu

      Of course!

      Thank you for your help

      Comment

      Working...