急需省关联市的代码

babyboyren 2004-09-03 12:54:48

现在帮我朋友做个网站，急需省关联市的代码
比如前面选湖南就显示湖南相关的市
还有一点，不要只显示，还要有附值了的。
谢谢。

...全文

343 27 打赏收藏转发到动态举报

写回复

用AI写文章

27 条回复

切换为时间正序

请发表友善的回复…

发表回复

babyboyren 2004-09-03

打赏
举报

高手来啊,怎么大家都只有这个代吗啊.HELP

babyboyren 2004-09-03

打赏
举报

to lhl62301:
你发的我已收到,但这个我有了,它只有一个外壳,它没给<option value=""></option>中的VALUE赋值.没有参数传出,我怎能么调啊.高手继续帮忙啊

lhl62301 2004-09-03

打赏
举报

我给你发过去了！

babyboyren 2004-09-03

打赏
举报

TO LHL62301
THANKS,BABYBOYZHI@163.COM.发了告诉我一下啊

babyboyren 2004-09-03

打赏
举报

TO:SUPERDULLWOLF:
我这里是繁体系统,看不到你那个FTP空间的方件名.可以发到我的EMAIL:BABYBOYZHI@163.COM

babyboyren 2004-09-03

打赏
举报

这个我有啊,我只要2级的.而且这个没有联动的没有给VALUE值啊

lhl62301 2004-09-03

打赏
举报

太多了
告诉我邮箱
我发给你！

lhl62301 2004-09-03

打赏
举报

index.htm

<html>
<head>
<title> 省市县关联菜单 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="Generator" content="EditPlus">
<style>
body,select
{
font-size:9pt;
font-family:Verdana;
}
select {background-color:#F0F0F0;}
</style>
<script language="JavaScript" src="area.js"></script>
<SCRIPT LANGUAGE = JavaScript>

</SCRIPT>
</head>
<body bgcolor="#E0E0E0" onload="setup()">
多级关联菜单：
<form name="frm">
<select id="s1"></select>
<select id="s2"></select>
<select id="s3"></select>
</form>

</body>
</html>

超级大笨狼 2004-09-03

打赏
举报

http://www.adr.gov.cn/summit/statistics/DanWtj.asp
GB数据库

下载
ftp://csdn:csdn@61.152.210.28

babyboyren 2004-09-03

打赏
举报

谁有直接的代码啊.自己写好麻烦啊

shootarrow 2004-09-03

打赏
举报

以下是祖国省市二级联动SELECT
<script language = "JavaScript">
sall=new Array();
<%
Dim i
i=0
set rs2=server.createobject("adodb.recordset")
sqltext="select * from [region]"
rs2.open sqltext,conn,1,1
do while not rs2.eof
%>
sall[<%=i%>]=new Array("<%=rs2("region_name")%>","<%=rs2("region_province")%>","<%=rs2("region_id")%>");
<%
i=i+1
rs2.movenext
loop
rs2.close
%>
function changeselect(selvalue)
{
document.form.region.length=0;
var selvalue=selvalue;
var i;
for(i=0;i<sall.length;i++)
{
if(sall[i][1]==selvalue)
{
var newOption1=new Option(sall[i][0],sall[i][2]);
document.all.region.add(newOption1);
}
}
}
</script>
<form name="form" method="post" action="哈哈.asp">
<%set rs1=server.createobject("adodb.recordset")
sqltext="select * from [province]"
rs1.open sqltext,conn,1,1%>
<select name="province" onChange="changeselect(document.form.province.options[document.form.province.selectedIndex].value)" >
<option value="" selected>请选择</option>
<%do while not rs1.eof%>
<option value="<%=rs1("province_id")%>"><%=rs1("province_name")%></option>
<%rs1.movenext
loop
rs1.close
set rs1=nothing%>
</select>
<select name="region">
<option value="" selected>请选择</option>
</select>
</form>
———————————分割线——————————————
表结构
region表
字段名字段类型
region_id int
region_province smallint
region_name nvarchar
---------------------------
province表
字段名字段类型
province_id smallint
province_name nvarchar

yeskele 2004-09-03

打赏
举报

<%
sql = "select * from tsvcappl order by apid "
rs.open sql,conn,3,3
%>
<script language = "JavaScript">

</script>

<body>
<form name="form1">

<%
sql = "select * from city"
rs.open sql,conn,3,3
if rs.eof and rs.bof then
response.write "先添加欄目"
response.end
else
%>
<select name="province" onChange="changeselect1(this.value)" size="1">
<option>province</option>
<%
do while not rs.eof
%>
<option value="<%=trim(rs("rmno"))%>"><%=trim(rs("rmno"))%></option>

<%
rs.movenext
loop
end if
rs.close
%>
</select>

<select name="city">
<option>city</option>
</select>

</form>
</body>
</html>

二级联动的例子很多,可以去找找看哈.

babyboyren 2004-09-03

打赏
举报

老大,你提供的链接不能用啊,给的CSDN的页也打不开.还有谁知道啊

kingapex1 2004-09-03

打赏
举报

//动态改变Select
function SetSmallAreaSelect(objAreaSelect){

var objSelect = document.myForm.SmallAreaSelect;
objSelect.length=0; //恢复为空
var AreaID = objAreaSelect.options[objAreaSelect.selectedIndex].value;

for(var j =0 ;j<cat.length;j++){
if(cat[j][0]==AreaID){

objSelect.options[objSelect.length] =new Option(cat[j][2],cat[j][1]);

}
}

}

wsdzmhongm 2004-09-03

打赏
举报

http://expert.csdn.net/Expert/topic/1862/1862933.xml?temp=.2640192

http://expert.csdn.net/Expert/topic/2468/2468222.xml?temp=.3364221

wsdzmhongm 2004-09-03

打赏
举报

www.zjlzb.com/1.rar

babyboyren 2004-09-03

打赏
举报

可以了。THANKS。。。。

5400 2004-09-03

打赏
举报

<select size="1" name="szSheng" onChange=chsel()>
<option value="xxx" selected>请选择省份……</option>
<%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from szSheng order by shengno",conn,1,1
while not rs_s.eof
%>
<option value="<%=rs_s("ShengNo")%>"><%=trim(rs_s("ShengName"))%></option>
<%
rs_s.movenext
wend
rs_s.close
set rs_s=nothing
%>
</select>
<select size="1" name="szShi">
<option value="xxx" selected>请选择城市……</option>
</select>

下边这段加在后边．．．．．．．．．．

<script language=JavaScript>
<%dim i,j
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from szSheng order by shengorder",conn,1,1
%>
var selects=[];
selects['xxx']=new Array(new Option('请选择城市……','xxx'));
<%
for i=1 to rs_s.recordcount
%>
selects['<%=rs_s("ShengNo")%>']=new Array(
<%
set rs_s1=server.createobject("adodb.recordset")
rs_s1.open "select * from szShi where shengno="&rs_s("ShengNo"),conn,1,1
if rs_s1.recordcount>0 then
for j=1 to rs_s1.recordcount
if j=rs_s1.recordcount then
%>
new Option('<%=trim(rs_s1("shiname"))%>','<%=trim(rs_s1("shiNo"))%>'));
<% else
%>
new Option('<%=trim(rs_s1("shiname"))%>','<%=trim(rs_s1("shiNo"))%>'),
<%
end if
rs_s1.movenext
next
else
%>
new Option('','0'));
<%
end if
rs_s1.close
set rs_s1=nothing
rs_s.movenext
next
rs_s.close
set rs_s=nothing
%>
function chsel(){
with (document.shouhuoxx){
if(szSheng.value) {
szShi.options.length=0;

for(var i=0;i<selects[szSheng.value].length;i++){
szShi.add(selects[szSheng.value][i]);
}
}
}
}
</script>

决对能用，，符合你的要求．．．接分了．．哈哈

cyl180555 2004-09-03