php二级联动菜单改动版

/*********************************************************************************************
*****************************php二级联动菜单改动版***********************************
****************************************by garcon1986*****************************************
**********************************************************************************************/
2chain.php:
<mce:script language = "JavaScript"><!--

var onecount;
onecount=0;
subcat = new Array();
<?php
mysql_connect("localhost","charles","charles");
mysql_select_db( "_crm" );
$sql = "select * from site";
$result = mysql_query( $sql );
$count = 0;
while($res = mysql_fetch_row($result)){
?>
subcat[<?php echo $count ?>] = new Array("<?php echo $res[0]?>","<?php echo $res[2]?>","<?php echo $res[1]?>");
<?php
$count++;
}
echo "onecount=$count;";
?>
//联动函数
function changelocation(locationid)
{
document.myform.ctype.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][2] == locationid)
{
//var newOption1=new Option(subcat[i][1], subcat[i][0]);
//document.all.ctype.add(newOption1);
document.myform.ctype.options[document.myform.ctype.length] = new Option(subcat[i][1], subcat[i][0]);
}
}
}
// --></mce:script>
<form method="post" name="myform" action="ru_query.php">
<select name="type" onChange="changelocation(document.myform.type.options[document.myform.type.selectedIndex].value)" size="1">
<option selected value="">main</option>
<?php
$sql = "select * from entreprise";
$result = mysql_query( $sql );
while($res = mysql_fetch_row($result)){
?>
<option value="<?php echo $res[0]; ?>">