如何做，使用二级联动的下拉列表？知道的告诉我一下好吗？
如何做，二级联动的下拉列表？知道的告诉我一下好吗？而且下拉列表中的项目是数据库中的值，不是固定值．现在急需实现这样的功能．知道的告诉我一声吧，先谢谢了！！如有可以实现这样功能的小程序，也可发我邮箱里面，yas531@163.com. 我在这里将不胜感激！ 急需！！！再次谢过！！
2006-02-14 16:38
2006-02-14 17:12
<script language="javascript">
<!--
//从数据库中取出二级下拉菜单，存放在JS数组中
//城市信息(所属省代码,城市代码,城市名称)
var areaArray = new Array()
var areaCount
<%
Set rs_area = lObj.selValue("m_area","1=1","*")
for k=1 to rs_area.recordcount
%>areaArray[<%=k%>] = new Array("<%=rs_area("province")%>","<%=rs_area("area_code")%>","<%=rs_area("area_name")%>")
<%
rs_area.movenext
next
Set rs_area = nothing
%>areaCount = <%=k%>
function changelocation(locationid){
document.all("area_code").length=0;
var locationid=locationid;
var i;
for(i=1;i<areaCount;i++){
if(areaArray[i][0] == locationid){
document.all("area_code").options[document.all("area_code").length] = new Option(areaArray[i][2],areaArray[i][1]);
}
}
}
//-->
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>新增会员</title>
</head>
<body class="textarea1" style="margin:0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="title">--- 增加院校会员 ---</td>
</tr>
</table>
<form style="margin:0" name="CollegeForm" method="post" action="AddCollege0.asp" onSubmit="return AddFormSub();">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center">省、市</td>
<td>
<select name="province" class="inputbox" id="province" onChange="changelocation(document.CollegeForm.province.options[document.CollegeForm.province.selectedIndex].value)">
<%
'调用一级下拉菜单
Set rs_province = lObj.selValue("m_province","1=1 order by description","*")
first_province = rs_province(0)
do while not rs_province.eof
%> <option value="<%=rs_province("province")%>"><%=rs_province("description")%></option>
<%
rs_province.movenext
loop
Set rs_province = nothing
%>
</select>
<select name="area_code" class="inputbox" id="area_code">
</select>
</td>
</tr>
</table>
</form>
</body>
</html>
2006-02-15 09:00
2006-02-15 09:46
<script language="javascript">
<!--
//城市信息(所属省代码,城市代码,城市名称)
//可以从数据库从读取
var areaArray = new Array()
var areaCount
areaArray[1] = new Array("1","1","北京市")
areaArray[2] = new Array("10","1","沈阳市")
areaArray[3] = new Array("10","10","辽阳市")
areaArray[4] = new Array("10","11","盘锦市")
areaArray[5] = new Array("10","12","铁岭市")
areaArray[6] = new Array("10","13","朝阳市")
areaArray[7] = new Array("10","14","葫芦岛市")
areaArray[8] = new Array("10","2","大连市")
areaArray[9] = new Array("10","3","鞍山市")
areaArray[10] = new Array("10","4","抚顺市")
areaArray[11] = new Array("10","5","本溪市")
areaArray[12] = new Array("10","6","丹东市")
areaArray[13] = new Array("10","7","锦州市")
areaArray[14] = new Array("10","8","营口市")
areaArray[15] = new Array("10","9","阜新市")
areaArray[16] = new Array("11","1","长春市")
areaArray[17] = new Array("11","2","吉林市")
areaArray[18] = new Array("11","3","四平市")
areaArray[19] = new Array("11","4","辽源市")
areaArray[20] = new Array("11","5","本溪市")
areaArray[21] = new Array("11","6","通化市")
areaArray[22] = new Array("11","7","白山市")
areaArray[23] = new Array("11","8","白城市")
areaArray[24] = new Array("11","9","延边朝鲜族自治州")
areaArray[25] = new Array("12","1","哈尔滨市")
areaArray[26] = new Array("12","10","牡丹江市")
areaArray[27] = new Array("12","11","黑河市")
areaArray[28] = new Array("12","12","绥化市")
areaArray[29] = new Array("12","13","大兴安岭地区")
areaArray[30] = new Array("12","2","齐齐哈尔市")
areaArray[31] = new Array("12","3","鸡西市")
areaArray[32] = new Array("12","4","鹤岗市")
areaArray[33] = new Array("12","5","双鸭山市")
areaArray[34] = new Array("12","6","大庆市")
areaArray[35] = new Array("12","7","伊春市")
areaArray[36] = new Array("12","8","佳木斯市")
areaArray[37] = new Array("12","9","七台河市")
areaArray[38] = new Array("13","1","太原市")
areaArray[39] = new Array("13","10","临汾市")
areaArray[40] = new Array("13","11","吕梁市")
areaArray[41] = new Array("13","2","大同市")
areaArray[42] = new Array("13","3","阳泉市")
areaArray[43] = new Array("13","4","长治市")
areaArray[44] = new Array("13","5","晋城市")
areaArray[45] = new Array("13","6","朔州市")
areaArray[46] = new Array("13","7","晋中市")
areaArray[47] = new Array("13","8","运城市")
areaArray[48] = new Array("13","9","忻州市")
areaArray[49] = new Array("14","1","福州市")
areaArray[50] = new Array("14","2","厦门市")
areaArray[51] = new Array("14","3","莆田市")
areaArray[52] = new Array("14","4","三明市")
areaArray[53] = new Array("14","5","泉州市")
areaArray[54] = new Array("14","6","漳州市")
areaArray[55] = new Array("14","7","南平市")
areaArray[56] = new Array("14","8","龙岩市")
areaArray[57] = new Array("14","9","宁德市")
areaArray[58] = new Array("15","1","南昌市")
areaArray[59] = new Array("15","10","抚州市")
areaArray[60] = new Array("15","11","上饶市")
areaArray[61] = new Array("15","2","景德镇市")
areaArray[62] = new Array("15","3","萍乡市")
areaArray[63] = new Array("15","4","九江市")
areaArray[64] = new Array("15","5","新余市")
areaArray[65] = new Array("15","6","鹰潭市")
areaArray[66] = new Array("15","7","赣州市")
areaArray[67] = new Array("15","8","吉安市")
areaArray[68] = new Array("15","9","宜春市")
areaArray[69] = new Array("16","1","石家庄市")
areaArray[70] = new Array("16","10","廊坊市")
areaArray[71] = new Array("16","11","衡水市")
areaArray[72] = new Array("16","2","唐山市")
areaArray[73] = new Array("16","3","秦皇岛市")
areaArray[74] = new Array("16","4","邯郸市")
areaArray[75] = new Array("16","5","邢台市")
areaArray[76] = new Array("16","6","保定市")
areaArray[77] = new Array("16","7","张家口市")
areaArray[78] = new Array("16","8","承德市")
areaArray[79] = new Array("16","9","沧州市")
areaArray[80] = new Array("17","1","郑州市")
areaArray[81] = new Array("17","10","许昌市")
areaArray[82] = new Array("17","11","漯河市")
areaArray[83] = new Array("17","12","三门峡市")
areaArray[84] = new Array("17","13","南阳市")
areaArray[85] = new Array("17","14","商丘市")
areaArray[86] = new Array("17","15","信阳市")
areaArray[87] = new Array("17","16","周口市")
areaArray[88] = new Array("17","17","驻马店市")
areaArray[89] = new Array("17","18","济源市")
areaArray[90] = new Array("17","2","开封市")
areaArray[91] = new Array("17","3","洛阳市")
areaArray[92] = new Array("17","4","平顶山市")
areaArray[93] = new Array("17","5","焦作市")
areaArray[94] = new Array("17","6","鹤壁市")
areaArray[95] = new Array("17","7","新乡市")
areaArray[96] = new Array("17","8","安阳市")
areaArray[97] = new Array("17","9","濮阳市")
areaArray[98] = new Array("18","1","武汉市")
areaArray[99] = new Array("18","10","黄冈市")
areaArray[100] = new Array("18","11","咸宁市")
areaArray[101] = new Array("18","12","随州市")
areaArray[102] = new Array("18","13","恩施州")
areaArray[103] = new Array("18","14","仙桃市")
areaArray[104] = new Array("18","15","潜江市")
areaArray[105] = new Array("18","16","天门市")
areaArray[106] = new Array("18","17","神农架林区")
areaArray[107] = new Array("18","2","黄石市")
areaArray[108] = new Array("18","3","襄樊市")
areaArray[109] = new Array("18","4","十堰市")
areaArray[110] = new Array("18","5","荆州市")
areaArray[111] = new Array("18","6","宜昌市")
areaArray[112] = new Array("18","7","荆门市")
areaArray[113] = new Array("18","8","鄂州市")
areaArray[114] = new Array("18","9","孝感市")
areaArray[115] = new Array("19","1","长沙市")
areaArray[116] = new Array("19","10","郴州市")
areaArray[117] = new Array("19","11","永州市")
areaArray[118] = new Array("19","12","怀化市")
areaArray[119] = new Array("19","13","娄底市")
areaArray[120] = new Array("19","14","湘西州")
areaArray[121] = new Array("19","2","株洲市")
areaArray[122] = new Array("19","3","湘潭市")
areaArray[123] = new Array("19","4","衡阳市")
areaArray[124] = new Array("19","5","邵阳市")
areaArray[125] = new Array("19","6","岳阳市")
areaArray[126] = new Array("19","7","常德市")
areaArray[127] = new Array("19","8","张家界市")
areaArray[128] = new Array("19","9","益阳市")
areaArray[129] = new Array("2","1","天津市")
areaArray[130] = new Array("20","1","成都市")
areaArray[131] = new Array("20","10","乐山市")
areaArray[132] = new Array("20","11","南充市")
areaArray[133] = new Array("20","12","宜宾市")
areaArray[134] = new Array("20","13","广安市")
areaArray[135] = new Array("20","14","达州市")
areaArray[136] = new Array("20","15","眉山市")
areaArray[137] = new Array("20","16","雅安市")
areaArray[138] = new Array("20","17","巴中市")
areaArray[139] = new Array("20","18","资阳市")
areaArray[140] = new Array("20","19","阿坝州")
areaArray[141] = new Array("20","2","自贡市")
areaArray[142] = new Array("20","20","甘孜州")
areaArray[143] = new Array("20","21","凉山州")
areaArray[144] = new Array("20","3","攀枝花市")
areaArray[145] = new Array("20","4","泸州市")
areaArray[146] = new Array("20","5","德阳市")
areaArray[147] = new Array("20","6","绵阳市")
areaArray[148] = new Array("20","7","广元市")
areaArray[149] = new Array("20","8","遂宁市")
areaArray[150] = new Array("20","9","内江市")
areaArray[151] = new Array("21","1","贵阳市")
areaArray[152] = new Array("21","2","六盘水市")
areaArray[153] = new Array("21","3","遵义市")
areaArray[154] = new Array("21","4","安顺市")
areaArray[155] = new Array("21","5","铜仁地区")
areaArray[156] = new Array("21","6","毕节地区")
areaArray[157] = new Array("21","7","黔西南布依族苗族自治州")
areaArray[158] = new Array("21","8","黔东南苗族侗族自治州")
areaArray[159] = new Array("21","9","黔南布依族苗族自治州")
areaArray[160] = new Array("22","1","昆明市")
areaArray[161] = new Array("22","10","红河州")
areaArray[162] = new Array("22","11","西双版纳州")
areaArray[163] = new Array("22","12","楚雄州")
areaArray[164] = new Array("22","13","大理州")
areaArray[165] = new Array("22","14","德宏州")
areaArray[166] = new Array("22","15","怒江州")
areaArray[167] = new Array("22","16","迪庆州")
areaArray[168] = new Array("22","2","曲靖市")
areaArray[169] = new Array("22","3","玉溪市")
areaArray[170] = new Array("22","4","保山市")
areaArray[171] = new Array("22","5","昭通市")
areaArray[172] = new Array("22","6","丽江市")
areaArray[173] = new Array("22","7","思茅市")
areaArray[174] = new Array("22","8","临沧市")
areaArray[175] = new Array("22","9","文山州")
areaArray[176] = new Array("23","1","西安市")
areaArray[177] = new Array("23","10","商洛市")
areaArray[178] = new Array("23","2","铜川市")
areaArray[179] = new Array("23","3","宝鸡市")
areaArray[180] = new Array("23","4","咸阳市")
areaArray[181] = new Array("23","5","渭南市")
areaArray[182] = new Array("23","6","延安市")
areaArray[183] = new Array("23","7","汉中市")
areaArray[184] = new Array("23","8","榆林市")
areaArray[185] = new Array("23","9","安康市")
areaArray[186] = new Array("24","1","兰州市")
areaArray[187] = new Array("24","10","庆阳市")
areaArray[188] = new Array("24","11","定西市")
areaArray[189] = new Array("24","12","陇南市")
areaArray[190] = new Array("24","13","临夏州")
areaArray[191] = new Array("24","14","甘南州")
areaArray[192] = new Array("24","2","金昌市")
areaArray[193] = new Array("24","3","白银市")
areaArray[194] = new Array("24","4","天水市")
areaArray[195] = new Array("24","5","嘉峪关市")
areaArray[196] = new Array("24","6","武威市")
areaArray[197] = new Array("24","7","张掖市")
areaArray[198] = new Array("24","8","平凉市")
areaArray[199] = new Array("24","9","酒泉市")
areaArray[200] = new Array("25","1","西宁市")
areaArray[201] = new Array("25","2","海东地区")
areaArray[202] = new Array("25","3","海北藏族自治州")
areaArray[203] = new Array("25","4","黄南藏族自治州")
areaArray[204] = new Array("25","5","海南藏族自治州")
areaArray[205] = new Array("25","6","果洛藏族自治州")
areaArray[206] = new Array("25","7","玉树藏族自治州")
areaArray[207] = new Array("25","8","海西蒙古族藏族自治州")
areaArray[208] = new Array("26","1","南宁市")
areaArray[209] = new Array("26","10","百色市")
areaArray[210] = new Array("26","11","贺州市")
areaArray[211] = new Array("26","12","河池市")
areaArray[212] = new Array("26","13","来宾市")
areaArray[213] = new Array("26","14","崇左市")
areaArray[214] = new Array("26","2","柳州市")
areaArray[215] = new Array("26","3","桂林市")
areaArray[216] = new Array("26","4","梧州市")
areaArray[217] = new Array("26","5","北海市")
areaArray[218] = new Array("26","6","防城港市")
areaArray[219] = new Array("26","7","钦州市")
areaArray[220] = new Array("26","8","贵港市")
areaArray[221] = new Array("26","9","玉林市")
areaArray[222] = new Array("27","1","海口")
areaArray[223] = new Array("27","2","三亚")
areaArray[224] = new Array("28","1","呼和浩特市")
areaArray[225] = new Array("28","10","锡林郭勒盟")
areaArray[226] = new Array("28","11","阿拉善盟")
areaArray[227] = new Array("28","12","兴安盟")
areaArray[228] = new Array("28","2","包头市")
areaArray[229] = new Array("28","3","乌海市")
areaArray[230] = new Array("28","4","赤峰市")
areaArray[231] = new Array("28","5","通辽市")
areaArray[232] = new Array("28","6","鄂尔多斯市")
areaArray[233] = new Array("28","7","呼伦贝尔市")
areaArray[234] = new Array("28","8","巴彦淖尔市")
areaArray[235] = new Array("28","9","乌兰察布市")
areaArray[236] = new Array("29","1","拉萨市")
areaArray[237] = new Array("29","2","那曲地区")
areaArray[238] = new Array("29","3","昌都地区")
areaArray[239] = new Array("29","4","山南地区")
areaArray[240] = new Array("29","5","日喀则地区")
areaArray[241] = new Array("29","6","阿里地区")
areaArray[242] = new Array("29","7","林芝地区")
areaArray[243] = new Array("3","1","上海市")
areaArray[244] = new Array("30","1","银川市")
areaArray[245] = new Array("30","2","固原市")
areaArray[246] = new Array("30","3","石嘴山市")
areaArray[247] = new Array("30","4","吴忠市")
areaArray[248] = new Array("30","5","中卫市")
areaArray[249] = new Array("31","1","乌鲁木齐市")
areaArray[250] = new Array("31","10","昌吉回族自治州")
areaArray[251] = new Array("31","11","博尔塔拉蒙古自治州")
areaArray[252] = new Array("31","12","伊犁哈萨克自治州")
areaArray[253] = new Array("31","13","塔城地区")
areaArray[254] = new Array("31","14","阿勒泰地区")
areaArray[255] = new Array("31","15","石河子市")
areaArray[256] = new Array("31","16","阿拉尔市")
areaArray[257] = new Array("31","17","图木舒克市")
areaArray[258] = new Array("31","18","五家渠市")
areaArray[259] = new Array("31","2","克拉玛依市")
areaArray[260] = new Array("31","3","吐鲁番地区")
areaArray[261] = new Array("31","4","哈密地区")
areaArray[262] = new Array("31","5","和田地区")
areaArray[263] = new Array("31","6","阿克苏地区")
areaArray[264] = new Array("31","7","喀什地区")
areaArray[265] = new Array("31","8","克孜勒苏柯尔克孜自治州")
areaArray[266] = new Array("31","9","巴音郭楞蒙古自治州")
areaArray[267] = new Array("32","1","香港特别行政区")
areaArray[268] = new Array("33","1","澳门特别行政区")
areaArray[269] = new Array("34","1","台湾省")
areaArray[270] = new Array("35","1","国外")
areaArray[271] = new Array("4","1","重庆市")
areaArray[272] = new Array("5","1","合肥市")
areaArray[273] = new Array("5","10","滁州市")
areaArray[274] = new Array("5","11","淮南市")
areaArray[275] = new Array("5","12","阜阳市")
areaArray[276] = new Array("5","13","宿州市")
areaArray[277] = new Array("5","14","六安市")
areaArray[278] = new Array("5","15","亳州市")
areaArray[279] = new Array("5","16","池州市")
areaArray[280] = new Array("5","17","宣城市")
areaArray[281] = new Array("5","2","芜湖市")
areaArray[282] = new Array("5","3","蚌埠市")
areaArray[283] = new Array("5","4","淮南市")
areaArray[284] = new Array("5","5","马鞍山市")
areaArray[285] = new Array("5","6","淮北市")
areaArray[286] = new Array("5","7","铜陵市")
areaArray[287] = new Array("5","8","安庆市")
areaArray[288] = new Array("5","9","黄山市")
areaArray[289] = new Array("6","1","南京市")
areaArray[290] = new Array("6","10","扬州市")
areaArray[291] = new Array("6","11","镇江市")
areaArray[292] = new Array("6","12","泰州市")
areaArray[293] = new Array("6","13","宿迁市")
areaArray[294] = new Array("6","2","无锡市")
areaArray[295] = new Array("6","3","徐州市")
areaArray[296] = new Array("6","4","常州市")
areaArray[297] = new Array("6","5","苏州市")
areaArray[298] = new Array("6","6","南通市")
areaArray[299] = new Array("6","7","连云港市")
areaArray[300] = new Array("6","8","淮安市")
areaArray[301] = new Array("6","9","盐城市")
areaArray[302] = new Array("7","1","杭州市")
areaArray[303] = new Array("7","10","台州市")
areaArray[304] = new Array("7","11","丽水市")
areaArray[305] = new Array("7","2","宁波市")
areaArray[306] = new Array("7","3","温州市")
areaArray[307] = new Array("7","4","嘉兴市")
areaArray[308] = new Array("7","5","湖州市")
areaArray[309] = new Array("7","6","绍兴市")
areaArray[310] = new Array("7","7","金华市")
areaArray[311] = new Array("7","8","衢州市")
areaArray[312] = new Array("7","9","舟山市")
areaArray[313] = new Array("8","1","广州市")
areaArray[314] = new Array("8","10","肇庆市")
areaArray[315] = new Array("8","11","惠州市")
areaArray[316] = new Array("8","12","梅州市")
areaArray[317] = new Array("8","13","汕尾市")
areaArray[318] = new Array("8","14","河源市")
areaArray[319] = new Array("8","15","阳江市")
areaArray[320] = new Array("8","16","清远市")
areaArray[321] = new Array("8","17","东莞市")
areaArray[322] = new Array("8","18","中山市")
areaArray[323] = new Array("8","19","潮州市")
areaArray[324] = new Array("8","2","深圳市")
areaArray[325] = new Array("8","20","揭阳市")
areaArray[326] = new Array("8","21","云浮市")
areaArray[327] = new Array("8","3","珠海市")
areaArray[328] = new Array("8","4","汕头市")
areaArray[329] = new Array("8","5","韶关市")
areaArray[330] = new Array("8","6","佛山市")
areaArray[331] = new Array("8","7","江门市")
areaArray[332] = new Array("8","8","湛江市")
areaArray[333] = new Array("8","9","茂名市")
areaArray[334] = new Array("9","1","济南市")
areaArray[335] = new Array("9","10","泰安市")
areaArray[336] = new Array("9","11","日照市")
areaArray[337] = new Array("9","12","莱芜市")
areaArray[338] = new Array("9","13","临沂市")
areaArray[339] = new Array("9","14","德州市")
areaArray[340] = new Array("9","15","聊城市")
areaArray[341] = new Array("9","16","滨州市")
areaArray[342] = new Array("9","17","菏泽市")
areaArray[343] = new Array("9","2","青岛市")
areaArray[344] = new Array("9","3","淄博市")
areaArray[345] = new Array("9","4","枣庄市")
areaArray[346] = new Array("9","5","东营市")
areaArray[347] = new Array("9","6","烟台市")
areaArray[348] = new Array("9","7","潍坊市")
areaArray[349] = new Array("9","8","威海市")
areaArray[350] = new Array("9","9","济宁市")
areaCount = 351
function changelocation(locationid){
document.all("area_code").length=0;
var locationid=locationid;
var i;
for(i=1;i<areaCount;i++){
if(areaArray[i][0] == locationid){
document.all("area_code").options[document.all("area_code").length] = new Option(areaArray[i][2],areaArray[i][1]);
}
}
}
//-->
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>省、市</title>
</head>
<body>
<form style="margin:0" name="CorpForm" method="post" action="AddCorp0.asp" onSubmit="return AddFormSub();">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center">省、市</td>
<td>
<select name="province" class="inputbox" id="province" onChange="changelocation(document.CorpForm.province.options[document.CorpForm.province.selectedIndex].value)">
<!--可以从数据库从读取-->
<option value="5">安徽省</option>
<option value="33">澳门特别行政区</option>
<option value="1">北京市</option>
<option value="14">福建省</option>
<option value="24">甘肃省</option>
<option value="8">广东省</option>
<option value="26">广西壮族自治区</option>
<option value="21">贵州省</option>
<option value="35">国外</option>
<option value="27">海南省</option>
<option value="16">河北省</option>
<option value="17">河南省</option>
<option value="12">黑龙江省</option>
<option value="18">湖北省</option>
<option value="19">湖南省</option>
<option value="11">吉林省</option>
<option value="6">江苏省</option>
<option value="15">江西省</option>
<option value="10">辽宁省</option>
<option value="28">内蒙古自治区</option>
<option value="30">宁夏回族自治区</option>
<option value="25">青海省</option>
<option value="9">山东省</option>
<option value="13">山西省</option>
<option value="23">陕西省</option>
<option value="3">上海市</option>
<option value="20">四川省</option>
<option value="34">台湾省</option>
<option value="2">天津市</option>
<option value="29">西藏自治区</option>
<option value="32">香港特别行政区</option>
<option value="31">新疆维吾尔自治区</option>
<option value="22">云南省</option>
<option value="7">浙江省</option>
<option value="4">重庆市</option>
</select>
<select name="area_code" class="inputbox" id="area_code"></select>
</td>
</tr>
</table>
</form>
</body>
</html>
2006-02-15 12:29
2006-02-15 14:14
2006-02-16 11:35
2006-02-16 11:40
2006-02-16 11:53
