php dropdown menu with deafult selected value

Question

I am working on a PHP project as follows

 if( mysql_num_rows( $result ) > 0 ) {
    echo '<select name="officerlist">';
    while ( $rows = mysql_fetch_array ( $result ) ) {                       
       echo '<option>' . $rows['officer'] . '</option>';
       if ($types[ $maxindex ] == $rows['officer']){
        echo ' selected';
       }
    }
        echo '</select>';
}

I am able to populate the query result into the dropdown menu. However, I want to implement it to have a default selected value based on value from another array. (ie if $types[$maxindex] is found in $rows['officer'], it will auto select the value.).

Anyone able to advise?

Thank you and best regards!

King-of-IT · Accepted Answer · 2014-02-21 05:39:20Z

1

try this

if( mysql_num_rows($result)>0 ) {
echo '<select name="officerlist">';
while ( $rows = mysql_fetch_array ($result) ) {                       
if ($types[$maxindex] == $rows['officer']){
    echo '<option selected="selected">' . $rows['officer'] . '</option>';    
}
else
{
    echo '<option>' . $rows['officer'] . '</option>';

}
}
echo '</select>';

answered Feb 21, 2014 at 5:39

King-of-IT

5434 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jogesh_pi · Accepted Answer · 2014-02-21 05:56:05Z

0

should be like this,

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

    if ($types[$maxindex] == $rows['officer']){
        echo '<option selected="selected" value="'.$rows['officer'].'">' . $rows['officer'] . '</option>';
    } else {
       echo '<option value="'.$rows['officer'].'">' . $rows['officer'] . '</option>';
    }
   }

edited Feb 21, 2014 at 5:56

answered Feb 21, 2014 at 4:56

jogesh_pi

9,7745 gold badges40 silver badges65 bronze badges

6 Comments

kenAu89 Over a year ago

Hi jogesh_pi, thank you for the prompt response. Did compiled the suggested codes but value is still not displaying as default.

jogesh_pi Over a year ago

@user3237459 what is this $maxindex? it simply means the condition not match in if ($types[$maxindex] == $rows['officer']){ part, Try to debug it to echo the $types[$maxindex] and check what value your are matching with.

kenAu89 Over a year ago

hello. yes it is matching. did an echo to verify its content. It is one of the matching selection found in $rows['officer'].

jogesh_pi Over a year ago

@user3237459 take a look on html source code or use firebug / developer's toolkit and verify that you get the value like <option selected="selected"> or not.

kenAu89 Over a year ago

hi, retrieved from page source : <option selected="selected" >Mr John</option>. It is the value matching $types[$maxindex]. However, it is not shown as default highlighted when displaying the page.

|

Krish R · Accepted Answer · 2014-02-21 05:08:33Z

0

You need add the selected attribute inside the <option> tag, like

<option selected='selected'>youroption</option>.

Try this,

if( mysql_num_rows($result)>0 ) {
    echo '<select name="officerlist">';
    while ( $rows = mysql_fetch_array ($result) ) {
        $selected ="";
        if ($types[$maxindex] == $rows['officer']){
            $selected = ' selected="selected" ';
        }
        echo '<option '.$selected.'>' . $rows['officer'] . '</option>';

    }
    echo '</select>';
}

answered Feb 21, 2014 at 5:08

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Comments

user3270303 · Accepted Answer · 2014-02-21 05:13:49Z

0

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

    if ($types[$maxindex] == $rows['officer']){
        echo '<option SELECTED>' . $rows['officer'] . '</option>';
    } else {
       echo '<option>' . $rows['officer'] . '</option>';
    }
   }

answered Feb 21, 2014 at 5:13

user3270303

Collectives™ on Stack Overflow

php dropdown menu with deafult selected value

4 Answers 4

Comments

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related