Question

怎么把php菜单循环显示数据库的信息提取出来？急！急！急！

$rs = mysql_query("select distinct staff_national from staff_info");
<select name="select_national" id="select_national">
<option value="0" selected="selected">民族</option>
<?php while($record=mysql_fetch_array($rs)){?>
<option value="<?php echo $record["staff_national"] ?>"><?php echo $record["staff_national"]; ?></option>
<?php } ?>
</select>

用意是：在菜单中显示数据库中已有不重复的信息，然后选择菜单下拉项后，把选择的项用echo输出

Answer 1

<select name="select_national" id="select_national">
<option value="0" selected="selected">民族</option>
<?php
while($record=mysql_fetch_array($rs)){
?>
<option value="<?php=$record['staff_national'] ?>"><?php=$record['staff_national']?></option>
<?php
}
?>
</select>

Answer 2

<?php
$query = mysql_query("SELECT DISTINCT id,staff_national FROM staff_info");
$html = '<select name="select_national" id="select_national"><option value="0" selected="selected">民族</option>';
while($value = mysql_fetch_array($query)){
$html .= '<option value="'.$value['id'].'">'.$value['staff_national'].'</option>';
}
$html .= '</select>';
echo $html;
?>

Answer 3

<option value="<?php echo $record["staff_national"] ?>"><?php echo $record["staff_national"]; ?></option>

第一个php标签输出的内容是数据库中属性字段，第二个应该echo内容字段。

Answer 4

用php+ajax比较好