一个数据表的3级连动问题，急！

[idea888]

数据表结构
----------------------------------
id classname classflag
1 大类1 0
2 大类1-1 1
3 大类1-1-1 2
。。。。。。。。。。。。。。。。。。
说明：
1：字段：id是自动编号，classname是类名，classflag是类别所属
2：classflag说明：为0代表一级分类；非0的情况下其值就为它上级类别的id号
3：语言基于asp就行，关键对表单里面js对表单元素动态传值不太懂，我想这个是我问问题的关键

基本情况就是这样，怎么实现三级连动
本人对javascript不太熟悉，请高手们指教一下小弟，谢谢了！

[kyyzy]

这个各数型 差不多
我给你讲原理吧 （只说两层 三层一样的道理）
你一行 控制下面一行显示或不显示
(javascript)控制表格 有这样一个属性
sytle"display:none"//不显示
sytle"display:blcok"//显示
就这样 其它的自己想

[lantersen]

把数据组织成下面例子格式,再自行调试下:
<FORM name="isc">
<table border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<td nowrap height="11">  

<select name="example" size="1" onChange="redirect(this.options.selectedIndex)">
<option selected>---Select1-------------</option>
<option>Webmaster Sites</option>
<option>News Sites</option>
</select>

<select name="stage2" size="1" onChange="redirect1(this.options.selectedIndex)">
<option value=" " selected> </option>
<option value=" " selected>---Select2--------------</option>
<option value=" " selected>---Select2--------------</option>
</select>

<select name="stage3" size="1" onChange="redirect2(this.options.selectedIndex)">
<option value=" " selected> </option>
<option value=" " selected>---Select3----------------</option>
<option value=" " selected>---Select3----------------</option>
</select>

<script>
<!--

/*
Triple Combo Script Credit
By Hamid Cheheltani/ Website Abstraction (http://www.wsabstract.com)
Visit http://wsabstract.com for this and over 400+ other scripts
*/

var groups=document.isc.example.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group[i]=new Array()

group[0][0]=new Option("---Select2---"," ");
group[1][0]=new Option("Now Select This One"," ");
group[1][1]=new Option("JavaScript","47");
group[1][2]=new Option("DHTML","46");
group[1][3]=new Option("CGI","45");
group[2][0]=new Option("Now Select This One"," ");
group[2][1]=new Option("General News","115");
group[2][2]=new Option("Technology News","116");

var temp=document.isc.stage2


function redirect(x){
for (m=temp.options.length-1;m>0;m--)
temp.options[m]=null
for (i=0;i<group[x].length;i++){
temp.options[i]=new Option(group[x][i].text,group[x][i].value)
}
temp.options[0].selected=true
redirect1(0)
}



var secondGroups=document.isc.stage2.options.length
var secondGroup=new Array(groups)
for (i=0; i<groups; i++) {
secondGroup[i]=new Array(group[i].length)
for (j=0; j<group[i].length; j++) {
secondGroup[i][j]=new Array() }}

secondGroup[0][0][0]=new Option("---Select 3---"," ");
secondGroup[1][0][0]=new Option("---Select 3---"," ");
secondGroup[1][1][0]=new Option("Now Select This One"," ");
secondGroup[1][1][1]=new Option("Website Abstraction","http://wsabstract.com");
secondGroup[1][1][2]=new Option("JavaScript for the non programmer","http://webteacher.com/javascript/");
secondGroup[1][1][3]=new Option("Java-Scripts.net","http://java-scripts.net");

secondGroup[1][2][0]=new Option("Now Select This One"," ");
secondGroup[1][2][1]=new Option("Dynamic Drive","http://www.dynamicdrive.com");
secondGroup[1][2][2]=new Option("Beginner\'s Guide to DHTML","http://www.geocities.com/ResearchTriangle/Facility/4490/");
secondGroup[1][2][3]=new Option("Web Coder","http://webcoder.com/");

secondGroup[1][3][0]=new Option("Now Select This One"," ");
secondGroup[1][3][1]=new Option("CGI Resources","http://www.cgi-resources.com");
secondGroup[1][3][2]=new Option("Ada\'s Intro to CGI","http://adashimar.hypermart.net/");

secondGroup[2][0][0]=new Option("---Select 3---"," ");
secondGroup[2][1][0]=new Option("Now Select This One"," ");
secondGroup[2][1][1]=new Option("CNN","http://www.cnn.com");
secondGroup[2][1][2]=new Option("MSNBC","http://www.msnbc.com");
secondGroup[2][1][3]=new Option("ABC News","http://www.abcnews.com");

secondGroup[2][2][0]=new Option("Now Select A Page"," ");
secondGroup[2][2][1]=new Option("News.com","http://www.news.com");
secondGroup[2][2][2]=new Option("Wired","http://www.wired.com");

var temp1=document.isc.stage3
function redirect1(y){
for (m=temp1.options.length-1;m>0;m--)
temp1.options[m]=null
for (i=0;i<secondGroup[document.isc.example.options.selectedIndex][y].length;i++){
temp1.options[i]=new Option(secondGroup[document.isc.example.options.selectedIndex][y][i].text,secondGroup[document.isc.example.options.selectedIndex][y][i].value)
}
temp1.options[0].selected=true
}

function redirect2(z){
//window.location=temp1[z].value
}

//-->
</script>

</td>
</tr>
</table>
</FORM>

[wuxinlangman]

<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<script language="javascript">
function getNextDate(str){
if(document.getElementById("select").value==""){
document.getElementById("select1").innerHTML="";
document.getElementById("select2").innerHTML="";
}
var ee="<select onchange='getNext(this.value)'>";
ee +="<option value=>请选择</option>";

for(i=0;i<10;i++){
str +="省"+i;
ee +="<option value="+str+">"+str+"</option>";
}
ee +="</select>"
document.getElementById("select1").innerHTML=ee;
}
function getNext(str1){
var ee1="<select>";
ee1 +="<option value=>请选择</option>";

for(i=0;i<10;i++){
str1 +="市"+i;
ee1 +="<option value="+str1+">"+str1+"</option>";
}
ee1 +="</select>"
document.getElementById("select2").innerHTML=ee1;
}
</script>
</HEAD>

<BODY>

</select>
<TABLE>
<TR>
<TD><select id="select" onchange='getNextDate(this.value)'>
<option value="">请选择</option>
<option value="河南">河南</option>
<option value="北京">北京</option></TD>
<TD id="select1"></TD>
<TD id="select2"></TD>
</TR>
</TABLE>
</BODY>
</HTML>
大概就是这个思路你自己整理一下主要是思路清晰就可以了

[fivetwogtt]

http://www.51windows.net/hw/asp/jsview.asp?id=347

[longxin123]

顶顶~~

[kafly]

数据多不多？
会不会要用JS传值给ASP再到SQL筛选？

这样的话，我以前好象有发一个例子，三级连动的，一级一级从数据库读。

[xinfudepangbian]

kafly(王者)

能给我一份源码吗

[e-mail]

谢了

[wuxinlangman]

加群28878407自己拿