[求助]二级连动菜单问题！
我仿造别人的一个连动选择菜单，下拉框的值都是从数据库中读取的，可是取不到值，不知道那里有问题？
PHP连动下拉菜单
<html>
<head>
<title>List</title>
<meta http-equiv="Content-Type" content="text/html; charset=??????">
<?php
//连接数据库
include("../../funcs/funcs.php");
$conn=localConnectUsm() or die("无法连接数据库！");
$sql="select * from College ";
$results= mssql_query($sql);
$rs=mssql_fetch_array($results) ;
?>
<script language = "JavaScript">
var onecount;
onecount = 0;
subcat = new Array();
<?
$count=0;
while($rs=mysql_fetch_array($results)){
?>
subcat[<?=$count;?>] = new Array("<?=$rs['schoolCode'];?>","<?=$rs['collegeCode'];?>","<?=$rs['collegeName'];?>","<?=$rs['SrvNo']?>"?>");
<?
$count++;
}
?>
onecount=<?=$count?>;
function GetCode(collegeCode){
var collegeCode=collegeCode;
var i;
for(i=0;i < onecount; i++){
if(subcat[1] == collegeCode){
document.sysuserform.SrvNo.value = subcat[3];
}
}
}
function ClearCode()
{
document.sysuserform.SrvNo.value = '';
}
function GetCity(schoolCode)
{
document.sysuserform.collegeCode.length = 0;
var schoolCode=schoolCode;
var i;
document.sysuserform.collegeCode.options[0] = new Option('==所选学院==','');
for (i=0;i < onecount; i++)
{
if (subcat[0] == schoolCode)
{
document.sysuserform.collegeCode.options[document.sysuserform.collegeCode.length] = new Option(subcat[2], subcat[1]);
}
}
}
</script>
</head>
<body>
<form name="sysuserform" method="post" action="">
分类：<select name="schoolCode" onChange="GetCity(document.sysuserform.schoolCode.options[document.sysuserform.schoolCode.selectedIndex].value);ClearCode();" size="1">
<option selected>请选择你所在的学校</option>
<?
$conn=localConnectUsm();
$sql1= "select * from School";
$query=mysql_query($sql1);
$a=mysql_num_rows($query);
while($rs1=mysql_fetch_array($query)){
?>
<option value="<?=$rs1['schoolCode'];?>"><?=$rs1['schoolName'];?></option>
<? }?>
</select>
<select name="collegeCode" onChange="GetCode(document.sysuserform.collegeCode.options[document.sysuserform.collegeCode.selectedIndex].value);">
<option selected value="">==所有学院==</option>
</select>
<INPUT TYPE="text" NAME="SrvNo">
<INPUT TYPE="submit">
</form>
</body>
</html>
<?php
if(!empty($_POST['collegeCode'])){
echo $_POST['collegeCode'];
}
?>
