<html><head>
<script language="JavaScript">
function Options(str)
{
// alert("触发onchange事件自动加1");
s=Number(str)+1;
window.document.form_opt.num.value = s;
}
</script>
</head><body>
<form name="form_opt">
<select name="book" onChange="Options(window.document.form_opt.book.options[selectedIndex].value);">
<option selected>请选择教室
<?php
//Options(window.document.form_opt.book.options[selectedIndex].value);
$db=mysql_connect("localhost","root","333333") or die("数据库连接失败!");
mysql_select_db("wenjianku",$db);
$query="select * from tablename";
$result=mysql_query($query,$db);
while($data=mysql_fetch_object($result))
{
$tmpname=$data->sortname;
$sortnum=$data->sortnum;
/* $q2="select name from aa where(id='$tmp')";
$r2=mysql_query($q2,$db);
while($d2=mysql_fetch_object($r2))
{
$str.=$d2->name.'*';
}*/
echo '<option value='.$sortnum.'>'.$tmpname.'</option>';
}
mysql_close($db);
?>
</select>
<input type="text" name="num">
号
</form>
</body></html>