HTML Option tag with selected value from PHP

Question

Can you please help me out as to what I am doing wrong with this code:

<option value="">------------ Select ------------</option>
<?php while (($row = mysql_fetch_array($tech))) {
                            ?>
<option value= <?php echo $row['id'] ?> 
<?php echo $selectedtechname ?>
<?php echo "selected" ?>
                          >
 <?php echo $row['technician_name'] ?></option>
                    <?php } ?>

All variables are working fine since I used Var_dump and they echo correctly so no errors is SQL etc. What I need to do is pass a php statement in the option tag of HTML to simply select the value of $selectedtechname from the list. The value to post is $row['id'] but the selected value to show should be $selectedtechname

Thanks

Looks like you are missing the closing curly bracket for the while loop. — dudeman, Mar 26 '15 at 17:24
possible duplicate of [PHP MySQL Drop Down Box Populate Selected Value](http://stackoverflow.com/questions/6725263/php-mysql-drop-down-box-populate-selected-value) — Sean, Mar 26 '15 at 17:36

Parangan · Answer 1 · 2015-03-26T17:29:02.627

1

You can try the following:

 $selected='';
    <option value="">Select a value</option>
    <?php
    while ($row = mysql_fetch_array($tech)) {
    ?>
       <?php
         if($selectedtechname == $row['selectedtechname'])
          {
             $selected='selected';
          }
          else
          {
            $selected='';
          }
        ?>
    <option value="<?php echo $row['id']?>" <?php echo $selected;?> ><?php echo $row['value_to_display'];?></option>

    <?php
    }
    ?>

edited Mar 26 '15 at 17:29

answered Mar 26 '15 at 17:28

Parangan

148
1
15

How do you know OP has `$row['selectedtechname']` as database field name? – Keep Coding Mar 26 '15 at 17:28
1

assuming that. bcoz he did not mentioned it. – Parangan Mar 26 '15 at 17:30
then consider using `if ($row['id'] == $selectedtechname) {` possibly OP needs this. – Keep Coding Mar 26 '15 at 17:32
I would stay with `if($selectedtechname == $row['selectedtechname'])` as that seems the most logical, give the OPs code. – Sean Mar 26 '15 at 17:33
May be.. @ OP I do not know by $selectedtechname what you are matching then use correspondin in $row['your_corresponding_field'] – Parangan Mar 26 '15 at 17:34

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

I see a similar post populate a select box with php mysql

while($row = mysql_fetch_assoc($result)) {
   if ($row['technician_name'] == $selectedtechname) {
       echo '<option   value=\"'.$row['id'].'" selected>'.$row['id'].'</option>';
   } else {
       echo '<option   value=\"'.$row['id'].'">'.$row['id'].'</option>';
   }
}

edited May 23 '17 at 11:56

Community

1
1

answered Mar 26 '15 at 17:31

Jacob Benny John

71
6

I think the OP needs `if ($row['technician_name'] == $selectedtechname)` – Sean Mar 26 '15 at 17:32

HTML Option tag with selected value from PHP

2 Answers2