select三级关联问题，就像省，市，县一样，并且都是从数据库读取出来，三个表！怎么关联

选一的时候，
运行VBScript，提交一下，
生出二，
选二的时候，再提交，

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//CN">
<HTML>
<HEAD>
<TITLE> Q2306615 </TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META NAME="Generator" CONTENT="Microsoft Notepad">
<META NAME="Author" CONTENT="Topmonkey">
<META NAME="Description" CONTENT="Re: Q2306615">
</HEAD><BODY bgcolor="#FFFFFF" leftmargin="0" topmargin="0"><SCRIPT LANGUAGE="JavaScript">

</SCRIPT><SELECT name=selProvince onchange="provinceChange(this.value)">
  <OPTION selected value=noselected nowrap>---请选择---</OPTION>
  <OPTION value=0 >浙江    </OPTION>
  <OPTION value=1 >山西    </OPTION>
  <OPTION value=2 >重庆    </OPTION>
  <OPTION value=3 >贵州    </OPTION>
  <OPTION value=4 >河南    </OPTION>
  <OPTION value=5 >江苏    </OPTION>
  <OPTION value=6 >宁夏    </OPTION>
  <OPTION value=7 >河北    </OPTION>
  <OPTION value=8 >新疆    </OPTION>
  <OPTION value=9 >四川    </OPTION>
  <OPTION value=10>山东    </OPTION>
  <OPTION value=11>黑龙江  </OPTION>
  <OPTION value=12>上海    </OPTION>
  <OPTION value=13>天津    </OPTION>
  <OPTION value=14>青海    </OPTION>
  <OPTION value=15>海南    </OPTION>
  <OPTION value=16>江西    </OPTION>
  <OPTION value=17>吉林    </OPTION>
  <OPTION value=18>厦门    </OPTION>
  <OPTION value=19>大连    </OPTION>
  <OPTION value=20>甘肃    </OPTION>
  <OPTION value=21>北京    </OPTION>
  <OPTION value=22>广西    </OPTION>
  <OPTION value=23>宁波    </OPTION>
  <OPTION value=24>福建    </OPTION>
  <OPTION value=25>辽宁    </OPTION>
  <OPTION value=26>深圳    </OPTION>
  <OPTION value=27>陕西    </OPTION>
  <OPTION value=28>湖南    </OPTION>
  <OPTION value=29>广东    </OPTION>
  <OPTION value=30>青岛    </OPTION>
  <OPTION value=31>安徽    </OPTION>
  <OPTION value=32>内蒙古  </OPTION>
  <OPTION value=33>云南    </OPTION>
  <OPTION value=34>湖北    </OPTION>
</SELECT>省<SELECT NAME="selCity">
<OPTION value=0>---请选择---</OPTION>
</SELECT></BODY>
</HTML>
我的想法：
<select name="select1" onchange="javascript:change()">...
<select name="select2" onchange="javascript:change()">...
<select name="select3">...
function change()
{
//读取数据，把下一级的<option>换调
}
这样不用每次把数据都读遍，我作国两个<select>的级联，三个可能要麻烦一点
to sx1123
   你的想法很好，也正在是我的想得到，关关键是在change中怎么写呀，我对javascript中是初学!不过还是谢谢你
想法：通过IFRAME的REPLACE来更新SELECT的信息，在REPLACE中调用的ASP返回可以更新三个SELECT的JS.
如果大家有源代码能否贴出来或发给我，[email protected]分如果不够，我再加，拼了命也要把这个做出来呀，不然得炒了呀，55555555555555，
我只做了两级,其实三级.两级都是一样做<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
</head><body>
<SELECT name="Country" onchange="ChgCountry()">
<OPTION SELECTED>－请选择国家－</OPTION>
<OPTION value="CHINA"> 中国</OPTION>
<OPTION value="US"> 美国</OPTION>
<OPTION value="ENG"> 英国</OPTION>
<OPTION value="JP"> 日本</OPTION>
</SELECT>
<SELECT name="City">
<OPTION SELECTED>－请选择城市－</OPTION>
</SELECT>
</body>
</html>
<script language="JavaScript" type="text/JavaScript">
var ChinaCity = new Array("安徽","澳门","北京","重庆","福建","甘肃","广东","广西","贵州","海南","河北","黑龙江","河南","湖北","湖南","江苏","江西","吉林","辽宁","内蒙古","宁夏","青海","陕西","山东","山西","上海","四川","台湾","天津","新疆","香港","西藏","云南","浙江");
var UsCity = new Array("城市一","城市二","城市三","城市四");
var EngCity = new Array("城市A","城市B","城市C","城市D");
var JpCity = new Array("城市a","城市b","城市c","城市d");
function ChgCountry() {

var SelValue = "";
var SelSize = 0;
var RightSel = window.City;
var NewOption;
var stCity = new Array();
for(var i=RightSel.length-1; i>=0; i--){
RightSel.remove(i);
}
SelValue = Country.options[Country.selectedIndex].value;
if(SelValue == "CHINA") {
stCity = ChinaCity;
} else if(SelValue == "US") {
stCity = UsCity;
} else if(SelValue == "ENG") {
stCity = EngCity;
} else if(SelValue == "JP") {
stCity = JpCity;
} else if(SelValue == "") {
NewOption = document.createElement("OPTION");
NewOption.text = "－请在左侧选择相应的国家－";
RightSel.add(NewOption);
return;
}
SelSize = stCity.length;
for(var i=0; i<SelSize; i++) {
NewOption = document.createElement("OPTION");
NewOption.text = stCity[i];
RightSel.add(NewOption);
}}
</script>
大体思路如下：
<div id="s1"><select name="select1">...</div><ifame id="fm"width=0 height=0></iframe>
...
<script language="vbscript">
function change()
   document.frames("fm").location.replace("aaa.asp")
end function
</script>aaa.asp:<%
'读数据库
Dim strTemp
strTemp="<select name='select1'><option value='"&rs("value")&"'>"&rs("value").....
%>
<script language="vbscript">
  parent.s1.innerHTML="<%=strTemp%>"
</script>
<%
response.end
%>
<%
'-----------------连动菜单----------------------
'----------------大类----------------------------
dim rd,rdsql
set rd=server.CreateObject("adodb.recordset")
rdsql="select * from cpfl"
rd.open rdsql,conn,3,3dim dl(100,1)
dim i1,count1
count1=rd.recordcount
i1=0
while not rd.eof
dl(i1,0)=rd("no")
dl(i1,1)=rd("leibie")
i1=i1+1
rd.movenext
wend
rd.close()
'----------小类-------------
dim rx,rxsql,i2,count2
set rx=server.CreateObject("adodb.recordset")
rxsql="select * from cp"
rx.open rxsql,conn,1,1
count2=rx.recordcount
dim xl(100,2)
i2=0
while not rx.eof
xl(i2,0)=rx("no")
xl(i2,1)=rx("mingcheng")
xl(i2,2)=rx("leibie")
i2=i2+1
rx.movenext
wend
rx.close()
%>
<script language="JavaScript">
function initlb()
{
lb=new Array();
<%for i=0 to count1-1%>
lb[<%=i%>]=new Array();
lb[<%=i%>][0]="<%=dl(i,0)%>"
lb[<%=i%>][1]="<%=dl(i,1)%>"
<%next%>
}
function initcp()
{
cp=new Array();
<%for i=0 to count2-1%>
cp[<%=i%>]=new Array();
cp[<%=i%>][0]="<%=xl(i,0)%>"
cp[<%=i%>][1]="<%=xl(i,1)%>"
cp[<%=i%>][2]="<%=xl(i,2)%>"
<%next%>
}
initlb()
initcp()
function changelb()
{
var selectleibie,i,j;
for(i=document.all.form1.cpmingcheng.options.length-1;i>=0;--i)
{
document.all.form1.cpmingcheng.options[i]=null;
}
selectleibie=document.all.cpleibie.options[document.all.cpleibie.selectedIndex].value;j=0;for(i=0;i<cp.length;i++)
{if (selectleibie==cp[i][2])
{
document.all.form1.cpmingcheng.options[j]=new Option(cp[i][1],cp[i][1]);
++j;
}
}
}</script>
这只是两级的，表的长度具体修改dl()和xl（）这两个数组，本人也是参考csdn上改写的