/********************************************************************************************* *****************************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]; ?>"><?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, name site: id, eid, name site中的eid即为entreprise的id。