php二级联动菜单改动版

sszxf

　　/**************************************************************************************************************************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[2] == locationid) {  //var newOption1=new Option(subcat[1], subcat[0]); //document.all.ctype.add(newOption1); document.myform.ctype.options[document.myform.ctype.length] = new Option(subcat[1], subcat[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]; ?>"><?php echo $res[1]; ?></option> <?php } ?> </select>  <select name="ctype">                 <option selected value="">sub</option> </select> <input type="submit" name="Submit" value="search"> </form>  数据库表格结构：entreprise: id, namesite: id, eid, namesite中的eid即为entreprise的id。