//以下是二级联动下拉代码
<%
sql = "select distinct subject,userid from exam_database order by subject"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
%>
subcat = new Array();
allsub = new Array();
<%
do while not rs.eof
%>
subcat[<%=counter%>] = new Array("<%= trim(rs("subject"))%>","<%= trim(rs("userid"))%>","<%= trim(rs("subject"))%>");
<%
counter = counter + 1
rs.movenext
loop
rs.close:set rs=nothing
sql="select distinct subject,userid from exam_database where userid='1' or userid='"&user&"' order by subject"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
do while not rs.eof
%>
allsub[<%=allcount%>] = new Array("<%= trim(rs("subject"))%>","<%= trim(rs("subject"))%>");
<%
allcount = allcount + 1
rs.movenext
loop
rs.close:set rs=nothing
%>
function changelocation(locationid)
{
var i,counter,allcount,locationid;
counter=<%=counter%>
allcount=<%=allcount%>
locationid=locationid;
document.subjectform.subject.length = 1;
if (locationid=="all")
{
for (i=0;i < allcount; i++)
{
document.subjectform.subject.options[document.subjectform.subject.length] = new Option(allsub[i][0], allsub[i][1]);
}
}
else
{
for (i=0;i < counter; i++)
{
if (subcat[i][1] == locationid)
{
document.subjectform.subject.options[document.subjectform.subject.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
}
<select name="database" onChange="changelocation(document.subjectform.database.options[document.subjectform.database.selectedIndex].value)">
<option selected>--请选择--</option>
<option value="all">所有</option>
<option value="1">系统</option>
<option value="<%=user%>">我的</option>
</select>
<option value="**">**</option>
</select>