<select name="select" onchange="location = this.options[this.selectedIndex].value;">
<?
$sql="select * from table where id='$id';
$query=mysql_query($sql);
while($row=mysql_fetch_array($query))
?>
<option value="<?$row['field']?>"><?$row['field']?></option>
</select>
<?
$sql="select * from table where id='$id';
$query=mysql_query($sql);
while($row=mysql_fetch_array($query))
?>
<option value="<?$row['field']?>"><?$row['field']?></option>
</select>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>
<table> <tr>
<td >
<? if(array_key_exists("flag",$_POST)) $flag=$_POST['flag'];
elseif(array_key_exists("flag",$_GET)) $flag=$_GET['flag'];
else $flag =""; if($flag !="")
{
echo "flag==".$flag;
}
else
{
$conn = mysql_pconnect("数据库ip","用户名","密码");//
$opened = mysql_select_db("test",$conn);//test是数据库
$strsql="SELECT * FROM music ORDER BY id";
$result = mysql_query($strsql,$conn);
echo "<select name='flag' onchange='blurJump(\"test.php\")'>\r\n";
while($row = mysql_fetch_array($result)){
echo "<option value='".$row["id"]."'>".$row["name"]."</option>\r\n";
}
echo "</select >\r\n";
}
?>
</td>
</tr>
</table>
</BODY>
</HTML> <script language=javascript>
function blurJump(url)
{
var ext = document.all.flag.value;
var linkurl = url + "?flag=" + ext;
document.location.href=linkurl ;
}
</script> ////这是数据库结构 #
# 表的结构 `music`
#CREATE TABLE `music` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;#
# 导出表中的数据 `music`
#INSERT INTO `music` VALUES (1, 'The Beatles');
INSERT INTO `music` VALUES (2, 'Bob Marley');
INSERT INTO `music` VALUES (3, 'The Byrds');
INSERT INTO `music` VALUES (4, 'The Doors');
INSERT INTO `music` VALUES (5, 'Kurt Cobain');
INSERT INTO `music` VALUES (6, '梅艳芳');
非常谢谢各位了~~~