关于关联互动的问题,帮我看看了。分不够在加 http://www.csdn.net/expert/topic/723/723099.xml?temp=.9384119 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <script language = "JavaScript">var onecount;onecount=0;subcat = new Array(); subcat[0] = new Array("ASP基础","2","1"); subcat[1] = new Array("ASP应用","2","2"); subcat[2] = new Array("ASP技巧","2","3"); subcat[3] = new Array("性能优化","2","4"); subcat[4] = new Array("安全加密","2","5"); subcat[5] = new Array("XML相关","2","6"); subcat[6] = new Array("全文检索","2","7"); subcat[7] = new Array("客户端相关","2","8"); subcat[8] = new Array("打印相关","2","9"); subcat[9] = new Array("数据库相关","2","10"); subcat[10] = new Array("入门教程","3","11"); subcat[11] = new Array("FTP/HTTP/Debug","3","12"); subcat[12] = new Array("XML应用","3","13"); subcat[13] = new Array("图像处理","3","14"); subcat[14] = new Array("数据库操作","3","15"); subcat[15] = new Array("文件处理","3","16"); subcat[16] = new Array("MS Access","5","17"); subcat[17] = new Array("MS SQL","5","18"); subcat[18] = new Array("DB2","5","19"); subcat[19] = new Array("Oracle","5","20"); subcat[20] = new Array("Application/Applet","4","21"); subcat[21] = new Array("J2EE/EJB/服务器","4","22"); subcat[22] = new Array("J2ME开发","4","23"); subcat[23] = new Array("Java基础","4","24"); subcat[24] = new Array("Java技巧及代码","4","25"); subcat[25] = new Array("Jsp/Servlet","4","26"); subcat[26] = new Array("正则表达式","2","27"); subcat[27] = new Array("系统相关","2","28"); subcat[28] = new Array("组件开发","2","29"); subcat[29] = new Array("脚本编码","2","30"); subcat[30] = new Array("远程脚本","2","31"); subcat[31] = new Array("邮件相关","2","32"); subcat[32] = new Array("FSO专题","2","33"); subcat[33] = new Array(".NET概论及软件使用","1","34"); subcat[34] = new Array("Asp.Net开发","1","35"); subcat[35] = new Array("C#语言","1","36"); subcat[36] = new Array("VB.net语言","1","37"); subcat[37] = new Array("E-mail专题","1","38"); subcat[38] = new Array("WebService","1","39"); subcat[39] = new Array("winform应用","1","40"); subcat[40] = new Array("window app开发","1","41"); subcat[41] = new Array("winsock应用","1","42"); subcat[42] = new Array("XML应用","1","43"); subcat[43] = new Array("数据库应用","1","44"); subcat[44] = new Array("综合应用","1","45"); subcat[45] = new Array("OO相关","1","46"); subcat[46] = new Array("文件操作","1","47"); subcat[47] = new Array("算法/线程","1","48"); subcat[48] = new Array("软件工程","1","49"); subcat[49] = new Array("面向对象程序基础","1","50"); subcat[50] = new Array("SOAP/UDDI/WSDL","1","51"); subcat[51] = new Array("控件开发和使用","1","52"); subcat[52] = new Array("MySQL","5","53"); subcat[53] = new Array("Sybase","5","54"); subcat[54] = new Array("DataWarehouse","5","55"); subcat[55] = new Array("Replication","5","56"); subcat[56] = new Array("Performance Turning","5","57"); subcat[57] = new Array("FAQ","5","58"); subcat[58] = new Array("邮件处理","3","59"); subcat[59] = new Array("开发工具","4","60"); subcat[60] = new Array("调试手记","4","61"); subcat[61] = new Array("面向对象/设计","4","62"); subcat[62] = new Array("企业级应用","4","63"); subcat[63] = new Array("嵌入式开发","4","64"); subcat[64] = new Array("Java与XML","4","65"); subcat[65] = new Array("资料/其它","4","66"); onecount=66;function changelocation(locationid) { document.myform.Nclassid.length = 0; var locationid=locationid; var i; for (i=0;i < onecount; i++) { if (subcat[i][1] == locationid) { document.myform.Nclassid.options[document.myform.Nclassid.length] = new Option(subcat[i][0], subcat[i][2]); } } } </script><form method="post" name="myform" action="ru_query.asp">文章搜索:<select name="action" size="1"><option value="title">文章标题</option></select><select name="classid" onChange="changelocation(document.myform.classid.options[document.myform.classid.selectedIndex].value)" size="1"> <option selected value="">未指定条件</option> <option value="1">.Net专区</option> <option value="2">ASP技术</option> <option value="3">PHP技术</option> <option value="4">JSP技术</option> <option value="5">数据库</option> </select> <select name="Nclassid"> <option selected value="">未指定条件</option> </select><input type="text" name="keyword" class=smallinput size=10 value="关键字" maxlength="50"><input type="submit" name="Submit" value="搜索"></form>搞定,ok,分拿来 我知道你看的是秋水无痕的帖子吧,写出来的吧。我的是用数据库中提出数据然后显示可是我的关联不是纯粹的两张表。它是通过内码表也就是A表了是通过incode的数值来判断的最前三位是B表的,中间三位是C表的后3位没在这写是D表的。他们通过A表的incode来关联的。你能搞定给你两百分。 SELECT section.id, section.name, build.id, build.name FROM build, incode incode_a, section, incode incode_b WHERE ( section.id = incode_a.outcode ) AND ( len(incode_a.incode) = 3 ) AND (len(incode_b.incode) = 6 AND incode_a.incode = left(incode_b.incode,3)) AND incode_b.outcode = build.id 用XML技術吧,都不用刷新頁面,select1 在onchange的時候,把select2全部刪除,再到後台取數據出來,插入select2即可啊for(var i = 0; i < select2.options.length; i++) //刪除 select2.remove(0);for(var i = 0; i < 讀出的長度; i++) //添加{ var s = document.createElement('option'); s.value = i - 0 + 1; s.text = 表3的nm; if(i == 0) s.selected = true; select2.add(s);}用XML取數據自己找吧,或者問我 在360浏览器跟IE浏览器中有些JS代码不执行? ie问题 讨论一下,javascript有办法在HTTP应答中设置SESSIONID吗? jqGrid怎么批量添加JSON数据?addJSonData怎么用? JavaScrip 函数 介绍一本学习JAVASCRIPT的好书! 谁能帮我把此程序改成能设置cookie有效期为1年的 一个函数传值出现的问题 如何改变树型菜单的背景颜色 html脚本怎么样调用API呢 发现IE未公开秘密 -- 真正意义上的全屏!!! 用自己写的菜单替换浏览器的菜单;象www.wecoo.com一样;
var onecount;
onecount=0;
subcat = new Array();
subcat[0] = new Array("ASP基础","2","1");
subcat[1] = new Array("ASP应用","2","2");
subcat[2] = new Array("ASP技巧","2","3");
subcat[3] = new Array("性能优化","2","4");
subcat[4] = new Array("安全加密","2","5");
subcat[5] = new Array("XML相关","2","6");
subcat[6] = new Array("全文检索","2","7");
subcat[7] = new Array("客户端相关","2","8");
subcat[8] = new Array("打印相关","2","9");
subcat[9] = new Array("数据库相关","2","10");
subcat[10] = new Array("入门教程","3","11");
subcat[11] = new Array("FTP/HTTP/Debug","3","12");
subcat[12] = new Array("XML应用","3","13");
subcat[13] = new Array("图像处理","3","14");
subcat[14] = new Array("数据库操作","3","15");
subcat[15] = new Array("文件处理","3","16");
subcat[16] = new Array("MS Access","5","17");
subcat[17] = new Array("MS SQL","5","18");
subcat[18] = new Array("DB2","5","19");
subcat[19] = new Array("Oracle","5","20");
subcat[20] = new Array("Application/Applet","4","21");
subcat[21] = new Array("J2EE/EJB/服务器","4","22");
subcat[22] = new Array("J2ME开发","4","23");
subcat[23] = new Array("Java基础","4","24");
subcat[24] = new Array("Java技巧及代码","4","25");
subcat[25] = new Array("Jsp/Servlet","4","26");
subcat[26] = new Array("正则表达式","2","27");
subcat[27] = new Array("系统相关","2","28");
subcat[28] = new Array("组件开发","2","29");
subcat[29] = new Array("脚本编码","2","30");
subcat[30] = new Array("远程脚本","2","31");
subcat[31] = new Array("邮件相关","2","32");
subcat[32] = new Array("FSO专题","2","33");
subcat[33] = new Array(".NET概论及软件使用","1","34");
subcat[34] = new Array("Asp.Net开发","1","35");
subcat[35] = new Array("C#语言","1","36");
subcat[36] = new Array("VB.net语言","1","37");
subcat[37] = new Array("E-mail专题","1","38");
subcat[38] = new Array("WebService","1","39");
subcat[39] = new Array("winform应用","1","40");
subcat[40] = new Array("window app开发","1","41");
subcat[41] = new Array("winsock应用","1","42");
subcat[42] = new Array("XML应用","1","43");
subcat[43] = new Array("数据库应用","1","44");
subcat[44] = new Array("综合应用","1","45");
subcat[45] = new Array("OO相关","1","46");
subcat[46] = new Array("文件操作","1","47");
subcat[47] = new Array("算法/线程","1","48");
subcat[48] = new Array("软件工程","1","49");
subcat[49] = new Array("面向对象程序基础","1","50");
subcat[50] = new Array("SOAP/UDDI/WSDL","1","51");
subcat[51] = new Array("控件开发和使用","1","52");
subcat[52] = new Array("MySQL","5","53");
subcat[53] = new Array("Sybase","5","54");
subcat[54] = new Array("DataWarehouse","5","55");
subcat[55] = new Array("Replication","5","56");
subcat[56] = new Array("Performance Turning","5","57");
subcat[57] = new Array("FAQ","5","58");
subcat[58] = new Array("邮件处理","3","59");
subcat[59] = new Array("开发工具","4","60");
subcat[60] = new Array("调试手记","4","61");
subcat[61] = new Array("面向对象/设计","4","62");
subcat[62] = new Array("企业级应用","4","63");
subcat[63] = new Array("嵌入式开发","4","64");
subcat[64] = new Array("Java与XML","4","65");
subcat[65] = new Array("资料/其它","4","66");
onecount=66;function changelocation(locationid)
{
document.myform.Nclassid.length = 0; var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.Nclassid.options[document.myform.Nclassid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script><form method="post" name="myform" action="ru_query.asp">
文章搜索:
<select name="action" size="1">
<option value="title">文章标题</option>
</select>
<select name="classid" onChange="changelocation(document.myform.classid.options[document.myform.classid.selectedIndex].value)" size="1">
<option selected value="">未指定条件</option>
<option value="1">.Net专区</option>
<option value="2">ASP技术</option>
<option value="3">PHP技术</option>
<option value="4">JSP技术</option>
<option value="5">数据库</option>
</select>
<select name="Nclassid">
<option selected value="">未指定条件</option>
</select>
<input type="text" name="keyword" class=smallinput size=10 value="关键字" maxlength="50">
<input type="submit" name="Submit" value="搜索">
</form>搞定,ok,分拿来
section.name,
build.id,
build.name
FROM build,
incode incode_a,
section,
incode incode_b
WHERE ( section.id = incode_a.outcode ) AND
( len(incode_a.incode) = 3 ) AND
(len(incode_b.incode) = 6 AND
incode_a.incode = left(incode_b.incode,3)) AND
incode_b.outcode = build.id
for(var i = 0; i < select2.options.length; i++) //刪除
select2.remove(0);
for(var i = 0; i < 讀出的長度; i++) //添加
{
var s = document.createElement('option');
s.value = i - 0 + 1;
s.text = 表3的nm;
if(i == 0) s.selected = true;
select2.add(s);
}
用XML取數據自己找吧,或者問我