在线等!请进来看~~!先拜谢!! http://expert.csdn.net/Expert/topic/2970/2970355.xml?temp=.1002924 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 连动问题:newbig:CREATE TABLE [dbo].[newbig] ([BigId] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,[bigtypes] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL )newmiddleCREATE TABLE [dbo].[newmiddle] ([middleid] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,[middletypes] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,[bigid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL )newsmallCREATE TABLE [dbo].[newSmall] ([Smallid] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,[SmallTypes] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,[middleid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL )<table width="498" border="0" cellspacing="0" cellpadding="0"> <tr> <td > <!-- #include file="conn.asp"--> <script language=javascript>function cc(theform5) {if ((theform5.txt.value=="") &&(theform5.sheng.value=="")&&(theform5.bigtypes.value=="")) { alert("查询条件都不能为空。"); theform5.txt.focus(); return false; } return true; }</script> <%sql = "select shengid,cityid,sheng,city from newcity order by cityid"set obj = conn.execute(sql)%> <script language = "JavaScript">var onecouant;onecouant=0;subcata = new Array(); <% count1 = 0 do while not obj.eof %>subcata[<%=count1%>] = new Array("<%= trim(obj("City"))%>","<%= trim(obj("shengid"))%>","<%= trim(obj("cityid"))%>"); <% count1 = count1 + 1 obj.movenext loop obj.close set obj=nothing %>onecouant=<%=count1%>;function changelocation3(id) { document.f1.city.length = 0; var id=id; var i; document.f1.city.options[0] = new Option('----------请选择城市---------',''); for (i=0;i < onecouant; i++) { if (subcata[i][1] == id) { document.f1.city.options[document.f1.city.length] = new Option(subcata[i][0], subcata[i][2]); } } } </script></td> </tr> </table> <form name="f1" method="post" action="newEnterprise/AllSearch.asp" onsubmit="return cc(f1)"> <table width="400" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr bgcolor="e6e6e6"> <td width="101" height="35" align="center"><strong>选择省份</strong></td> <td width="349" height="35"><select name="sheng" onChange="changelocation3(document.f1.sheng.options[document.f1.sheng.selectedIndex].value)" size="1"> <option value="" selected>----------请选择省份---------</option> <% sql1 = "select shengid,sheng from newsheng order by Shengid" set obj1 = conn.Execute (sql1) do while not obj1.eof %> <option value="<%=trim(obj1("Shengid"))%>"><%=trim(obj1("Sheng"))%></option> <% obj1.movenext loop obj1.close set obj1 = nothing %> </select></td> </tr> <tr bgcolor="e6e6e6"> <td width="101" height="35" align="center"><strong>地区(市)</strong></td> <td width="349" height="35"><select name="city" size="1"> <option value="" selected>------请选择城市------</option> </select></td> </tr> <script LANGUAGE="JavaScript"> changelocation3(document.f1.sheng.options[document.f1.sheng.selectedIndex].value); </script> <tr bgcolor="e6e6e6"> <td width="101" height="33" align="center"><strong>行业大类</strong></td> <td width="349" height="33"><% sql = "select bigid,middleid,middletypes from newmiddle order by middleid" set rs = conn.execute(sql) %> <script language = "JavaScript"> var onecount; onecount=0; subcat = new Array(); <% count = 0 do while not rs.eof %> subcat[<%=count%>] = new Array("<%= trim(rs("middletypes"))%>","<%= trim(rs("bigid"))%>","<%= trim(rs("middleid"))%>"); <% count = count + 1 rs.movenext loop rs.close set rs=nothing %> onecount=<%=count%>; function changelocation(locationid) { document.f1.middletypes.length = 0; var locationid=locationid; var i; document.f1.middletypes.options[0] = new Option('--中类行业--',''); for (i=0;i < onecount; i++) { if (subcat[i][1] == locationid) { document.f1.middletypes.options[document.f1.middletypes.length] = new Option(subcat[i][0], subcat[i][2]); } } } </script> <%sql2 = "select smalltypes,middleid,smallid from newsmall order by smallid" set rs2 = conn.execute(sql2) %> <script language = "JavaScript"> var onecount2; onecount2=0; subcat2 = new Array(); <% count2 = 0 do while not rs2.eof %> subcat2[<%=count2%>] = new Array("<%= trim(rs2("smalltypes"))%>","<%= trim(rs2("middleid"))%>","<%= trim(rs2("smallid"))%>"); <% count2 = count2 + 1 rs2.movenext loop rs2.close set rs2=nothing %> onecount2=<%=count2%>; function changelocation2(smalltypesid) { document.f1.smalltypes.length = 0; var smalltypesid=smalltypesid; var j; document.f1.smalltypes.options[0] = new Option('--小类行业--',''); for (j=0;j < onecount2; j++) { if (subcat2[j][1] == smalltypesid) { document.f1.smalltypes.options[document.f1.smalltypes.length] = new Option(subcat2[j][0], subcat2[j][2]); } } } </script> <select name="bigtypes" onChange="changelocation(document.f1.bigtypes.options[document.f1.bigtypes.selectedIndex].value)" size="1"> <option selected value="">--------选择大类行业---------</option> <% sql1 = "select bigid,bigtypes from newbig order by bigid"set rs1 = conn.Execute (sql1) do while not rs1.eof %> <option value="<%=trim(rs1("bigid"))%>"><%=trim(rs1("bigtypes"))%></option> <% rs1.movenext loop rs1.close set rs1 = nothing conn.close set conn=nothing %> </select></td> </tr> <tr bgcolor="e6e6e6"> <td width="101" height="35" align="center"><strong>行业中类</strong></td> <td width="349" height="35"><select name="middletypes" onChange="changelocation2(document.f1.middletypes.options[document.f1.middletypes.selectedIndex].value)"> <option value="" selected>--------选择中类行业---------</option> </select></td> </tr> <tr bgcolor="e6e6e6"> <td width="101" height="35" align="center"><strong>行业小类</strong></td> <td width="349" height="35"><select name="smalltypes" size="1"> <option value="" selected>--------选择小类行业---------</option> </select></td> </tr> <tr bgcolor="e6e6e6"> <td width="101" height="35"> </td> <td width="349" height="35"><input type="submit" name="Submit3" value=" 搜索 "> <input type="reset" name="Submit5" value=" 重写 "></td> </tr> </table> </form> php 写md5 绑定授权 PHP精鹰超级群43016622,百G视频书籍陆续加入! 急求怎样实现php中的页面返回? SELECT count(`tieba_info`.*) as `total`,错误了 两个表关联排序 count 无效了。。出错,怎么解决? 重新生成相同文件名的图片,页面显示的图片不刷新 AJAX如何调用PHP的类中的方法? 请教一下PHP高手帮我看一下 phpmyadmin中的乱码问题! to:southline(林材) sessionID是如何在客户端和服务器端传递的? 一天在单位无聊,但还是得上班,散分! 开个QQ群给来交流2597947
[BigId] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bigtypes] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL
)newmiddle
CREATE TABLE [dbo].[newmiddle] (
[middleid] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[middletypes] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bigid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
)newsmall
CREATE TABLE [dbo].[newSmall] (
[Smallid] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SmallTypes] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[middleid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
)<table width="498" border="0" cellspacing="0" cellpadding="0">
<tr>
<td > <!-- #include file="conn.asp"--> <script language=javascript>
function cc(theform5) {
if ((theform5.txt.value=="") &&(theform5.sheng.value=="")&&(theform5.bigtypes.value==""))
{ alert("查询条件都不能为空。");
theform5.txt.focus();
return false;
}
return true;
}
</script> <%
sql = "select shengid,cityid,sheng,city from newcity order by cityid"
set obj = conn.execute(sql)
%> <script language = "JavaScript">
var onecouant;
onecouant=0;
subcata = new Array();
<%
count1 = 0
do while not obj.eof
%>
subcata[<%=count1%>] = new Array("<%= trim(obj("City"))%>","<%= trim(obj("shengid"))%>","<%= trim(obj("cityid"))%>");
<%
count1 = count1 + 1
obj.movenext
loop
obj.close
set obj=nothing
%>
onecouant=<%=count1%>;function changelocation3(id)
{
document.f1.city.length = 0; var id=id;
var i;
document.f1.city.options[0] = new Option('----------请选择城市---------','');
for (i=0;i < onecouant; i++)
{
if (subcata[i][1] == id)
{
document.f1.city.options[document.f1.city.length] = new Option(subcata[i][0], subcata[i][2]);
}
}
}
</script></td>
</tr>
</table>
<form name="f1" method="post" action="newEnterprise/AllSearch.asp" onsubmit="return cc(f1)">
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr bgcolor="e6e6e6">
<td width="101" height="35" align="center"><strong>选择省份</strong></td>
<td width="349" height="35"><select name="sheng" onChange="changelocation3(document.f1.sheng.options[document.f1.sheng.selectedIndex].value)" size="1">
<option value="" selected>----------请选择省份---------</option>
<%
sql1 = "select shengid,sheng from newsheng order by Shengid"
set obj1 = conn.Execute (sql1)
do while not obj1.eof
%>
<option value="<%=trim(obj1("Shengid"))%>"><%=trim(obj1("Sheng"))%></option>
<%
obj1.movenext
loop
obj1.close
set obj1 = nothing
%>
</select></td>
</tr>
<tr bgcolor="e6e6e6">
<td width="101" height="35" align="center"><strong>地区(市)</strong></td>
<td width="349" height="35"><select name="city" size="1">
<option value="" selected>------请选择城市------</option>
</select></td>
</tr>
<script LANGUAGE="JavaScript">
changelocation3(document.f1.sheng.options[document.f1.sheng.selectedIndex].value);
</script>
<tr bgcolor="e6e6e6">
<td width="101" height="33" align="center"><strong>行业大类</strong></td>
<td width="349" height="33"><%
sql = "select bigid,middleid,middletypes from newmiddle order by middleid"
set rs = conn.execute(sql)
%> <script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("middletypes"))%>","<%= trim(rs("bigid"))%>","<%= trim(rs("middleid"))%>");
<%
count = count + 1
rs.movenext
loop
rs.close
set rs=nothing
%>
onecount=<%=count%>; function changelocation(locationid)
{
document.f1.middletypes.length = 0; var locationid=locationid;
var i;
document.f1.middletypes.options[0] = new Option('--中类行业--','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.f1.middletypes.options[document.f1.middletypes.length] = new Option(subcat[i][0], subcat[i][2]);
}
} }
</script> <%sql2 = "select smalltypes,middleid,smallid from newsmall order by smallid"
set rs2 = conn.execute(sql2)
%> <script language = "JavaScript">
var onecount2;
onecount2=0;
subcat2 = new Array();
<%
count2 = 0
do while not rs2.eof
%>
subcat2[<%=count2%>] = new Array("<%= trim(rs2("smalltypes"))%>","<%= trim(rs2("middleid"))%>","<%= trim(rs2("smallid"))%>");
<%
count2 = count2 + 1
rs2.movenext
loop
rs2.close
set rs2=nothing
%>
onecount2=<%=count2%>; function changelocation2(smalltypesid)
{
document.f1.smalltypes.length = 0; var smalltypesid=smalltypesid;
var j;
document.f1.smalltypes.options[0] = new Option('--小类行业--','');
for (j=0;j < onecount2; j++)
{
if (subcat2[j][1] == smalltypesid)
{
document.f1.smalltypes.options[document.f1.smalltypes.length] = new Option(subcat2[j][0], subcat2[j][2]);
}
} } </script> <select name="bigtypes" onChange="changelocation(document.f1.bigtypes.options[document.f1.bigtypes.selectedIndex].value)" size="1">
<option selected value="">--------选择大类行业---------</option>
<%
sql1 = "select bigid,bigtypes from newbig order by bigid"
set rs1 = conn.Execute (sql1)
do while not rs1.eof
%>
<option value="<%=trim(rs1("bigid"))%>"><%=trim(rs1("bigtypes"))%></option>
<%
rs1.movenext
loop
rs1.close
set rs1 = nothing
conn.close
set conn=nothing
%>
</select></td>
</tr>
<tr bgcolor="e6e6e6">
<td width="101" height="35" align="center"><strong>行业中类</strong></td>
<td width="349" height="35"><select name="middletypes" onChange="changelocation2(document.f1.middletypes.options[document.f1.middletypes.selectedIndex].value)">
<option value="" selected>--------选择中类行业---------</option>
</select></td>
</tr>
<tr bgcolor="e6e6e6">
<td width="101" height="35" align="center"><strong>行业小类</strong></td>
<td width="349" height="35"><select name="smalltypes" size="1">
<option value="" selected>--------选择小类行业---------</option>
</select></td>
</tr>
<tr bgcolor="e6e6e6">
<td width="101" height="35"> </td>
<td width="349" height="35"><input type="submit" name="Submit3" value=" 搜索 ">
<input type="reset" name="Submit5" value=" 重写 "></td>
</tr>
</table>
</form>