编辑下拉，但不显示选择的值从mysql数据库在php - Edit drop down but not showing selected value from mysql data base in php

Edit drop down but not showing selected value from mysql data base in php

我是php新手，我创建了从mysql数据库调用数据的下拉菜单，用户选择选项并将其保存到数据库

在编辑表单中出现问题，其中不显示所选值。

下拉代码如下:

$query = 'SELECT name FROM owner';
$result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
//create selection list
echo "<select name='owner'>'name";
while($row = mysql_fetch_row($result))
{
    $heading = $row[0];
    echo "<option value='$heading'>$heading'n";
}
echo "</select>"

请告知编辑表单的解决方案。

Thanks in Advance

必须关闭<option>标记:echo "<option value='$heading'>$heading</option>";

$query = 'SELECT name FROM owner';
$result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
//create selection list
echo "<select name='owner'>'name";
while($row = mysql_fetch_row($result))
{
    $heading = $row[0];
?>
    <option <?php if($heading=="SOMETHING") { echo "selected='selected'"; } ?> value="SOMETHING">SOMETHING</option>
<option <?php if($heading=="SOMETHING2") { echo "selected='selected'"; } ?> value="SOMETHING2">SOMETHING2</option>
<option <?php if($heading=="SOMETHING3") { echo "selected='selected'"; } ?> value="SOMETHING3">SOMETHING3</option>
<?php
}
echo "</select>"

我会这样做。

$numrows = mysql_num_rows($result);
if ($numrows != 0){
    echo "<select name='owner'>'name";
    while ($x = mysql_fetch_assoc($result)){
       echo "<option value='".$x['heading']."'>".$x['heading']."</option>";
    }
echo "</select>";
}

$x['heading']正在使用数据库中'heading'行的值