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

来源:百度知道 编辑:UC知道 时间:2024/05/27 04:15:09
$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输出

<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>

<?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;