$sql="select `name` from tb";
$result=mysql_query($sql);
echo "<select>";
while($ary=mysql_fetch_row($result)){
echo "<option>".$ary[name]."</option>";
}
echo "</select>";
$result=mysql_query($sql);
echo "<select>";
while($ary=mysql_fetch_row($result)){
echo "<option>".$ary[name]."</option>";
}
echo "</select>";
$sql="select name from tb";
$result=mysql_query($sql,$db_conn);
echo "<select>";
while($ary=mysql_fetch_row($result)){
echo "<option>".$ary["name"]."</option>";
}
echo "</select>";
你再看一下数据库中namer的大小写的问题
$sql="select name from 表名";
$query=mysql_db_query(数据库,$sql,连接号);
while($array=mysql_fetch_array($query)){
echo "<option value=\"$array[name]\">".$array[name]."</option>";
}
?>