一个简单的二级联动

<%

dim rsdim sqldim countdim rs1dim sql1sql = "SELECT * FROM class where parentid<>0"set rs = conn.execute(sql)%><script language = "JavaScript">var onecount;onecount=0;subcat = new Array(); <% count = 0 do while not rs.eof %>subcat[<%=count%>] = new Array("<%= trim(rs("name"))%>","<%= trim(rs("parentid"))%>","<%= trim(rs("cid"))%>"); <% count = count + 1 rs.movenext loop rs.close set rs=nothing %>onecount=<%=count%>;

function changelocation(locationid) { document.myform.sclassname.length = 0;

var locationid=locationid; var i; document.myform.sclassname.options[0] = new Option('=二级类别=',''); for (i=0;i < onecount; i++) { if (subcat[i][1] == locationid) { //alert(subcat[i][1]); document.myform.sclassname.options[document.myform.sclassname.length] = new Option(subcat[i][0], subcat[i][2]); } }

} </script>

<form action="" name="myform" method="post">

<table>

<tr> <td><div align="right">产品类别：</div></td> <td height="25"><label> <select name="bclassname" onChange="changelocation(document.myform.bclassname.options[document.myform.bclassname.selectedIndex].value)"> <% sql1 = "SELECT * FROM class where parentid=0" set rs1 = conn.Execute (sql1) do while not rs1.eof %> <option value="<%=trim(rs1("cid"))%>"><%=trim(rs1("name"))%></option> <% rs1.movenext loop rs1.close set rs1 = nothing conn.Close set conn = nothing %> </select> <select name="sclassname"> <option selected value="">=二级类别=</option> </select><script LANGUAGE="javascript"> //changelocation(document.myform.bclassname.options[document.myform.bclassname.selectedIndex].value); </script> </label></td> </tr>

</table>

</from>