28,390
社区成员
发帖
与我相关
我的任务
分享
<script language="javascript">
var region = new Array();
var dname = new Array();
<%
lastregion = ""
i = 0
e = 0
rs.open "select * from diqu order by region,dname",conn,1,1
while not rs.eof then
if lastregion <> rs("region") then
Response.write "region["+i+"]= '"+rs("region")+"';"
Response.write "dname["+i+"] = new Array();"
lastregion = rs("region")
i = i + 1
e = 0;
else
Response.write "region["+i+"]["+e+"]= Array("+rs("id")+",'"+rs("dname")+"');"
e = e + 1
end if
rs.movenext
wend
rs.close
%>
function showRegion(){
var region_opt = document.getElementById("region");
region_opt.length = 0;
for(var i=0;i<region.length;i++){
region_opt.options.add( new Option(region[i],i) );
}
}
function showDname( id ){
var dname_opt = document.getElementById("dname");
dname_opt.length = 0;
for(var i=0;i<dname[id].length;i++){
dname_opt.options.add( new Option(dname[id][i][1],dname[id][i][0]) );
}
}
</script>
<select name="region" id="region" onchange="showDname(this.value)"></select>
<select name="dname" id="dname"></select>
<script language="javascript">
showRegion()
</script>