选择每次都具有相同值的选项

Question

Looping from database duplicating the option values in options tag.

Please help me out.

My code is below.

<input type="hidden" name="beautician<?php echo $data[0]; ?>[]" id="beautician">
<select name="beautician[<?php echo $data[0]; ?>]" id="beauty" onchange="pvalue()">
    <option value="null">Select</option>
    <?php
    $query = "select id,title from beautician order by id";
    $run = mysql_query($query);
    while ($row = mysql_fetch_array($run)) {
        $id = $row[0];
        $name = $row[1];
        ?>
        <option value="<?php echo $id; ?>"> <?php echo $name; ?> </option>                                                         
    <?php } ?>
</select>

whenever the user is selecting beautician it is taking id of the first option.

If id of the first selected beautician is 6 then every other beautician will have id 6

Answer 1

Because you forgot to print $id

Correct

<option value="<?php $id;  ?>"> <?php echo $name; ?> </option>

To

<option value="<?php echo $id;  ?>"> <?php echo $name; ?> </option>