<script language = “JavaScript”>
var onecount;
onecount=0;
subcat=new Array();
<?php
$sql=”select a,b,c from table”;
$result=mysql_query( $sql ,$con);
$count=0;
while($res=mysql_fetch_row($result)){
?>
subcat[<?=$count?>]=new Array(”<?=$res[0]?>”,”<?=$res[1]?>”,”<?=$res[2]?>”);
<?
$count++;
}
echo “onecount=$count;”;
?>
//联动函数
function changelocation(locationid)
{
document.myform.Owner.length=0;
var locationid=locationid;
var i;
for(i=0;i<onecount;i++){
if (subcat[i][2] == locationid){
document.myform.Owner.options[document.myform.Owner.length] = new Option(subcat[i][1], subcat[i][0]);
}
}
}
</script>
