试试
<select name="field" size="1" onchange="window.location=this.value">
<?
$mysql_result=mysql_list_fields("zz","class",$id);$columns = mysql_num_fields($mysql_result);for ($i = 0; $i < $columns; $i++) {
echo "<option value=" . mysql_field_name($mysql_result, $i) . ">" . mysql_field_name($mysql_result, $i) . "</option>";
}
?></select>
<select name="field" size="1" onchange="window.location=this.value">
<?
$mysql_result=mysql_list_fields("zz","class",$id);$columns = mysql_num_fields($mysql_result);for ($i = 0; $i < $columns; $i++) {
echo "<option value=" . mysql_field_name($mysql_result, $i) . ">" . mysql_field_name($mysql_result, $i) . "</option>";
}
?></select>
$link = mysql_connect('localhost', 'myname', 'secret');$fields = mysql_list_fields("database1", "table1", $link);
$columns = mysql_num_fields($fields);for ($i = 0; $i < $columns; $i++) {
echo mysql_field_name($fields, $i) . "\n";;
}