神经科学原理 中文版:数据显示为什么循环7次?

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/29 06:59:46
下面的代码为什么预览的时候每条信息都显示7次呢?是语句有问题吗?还是跟别的页面或数据库有关系,我闹心死了,看了好久都没看出来,帮帮我!!为什么是7次呢!
<!--#include file="config.asp"-->
<!--#Include File="WrSky_Sql.Asp"-->
<!--#include file="conn.asp"-->
<!--#include file="code.asp"-->
<%
menu=htmlencode(request("menu"))
if menu="" or (not isnumeric(menu)) or isnull(menu) then
menu="all"
end if
set rs = server.createobject("adodb.recordset")
%>
。。。。。。。。。。。省略部分HTML
<TABLE cellSpacing=1 cellPadding=3 width=1004 align=center bgColor=#993300
border=0>
<TBODY>
<TR bgColor=#ff0000>
<TD width=770 align=middle background="image/oif.gif" bgColor=#0066CC>
<div align="right"><STRONG><FONT
color=#ffffff><B>↓所有已经发布的家族 牢记本站永久域名:http://www.allsifu.com 介绍给您的朋友们↓</b></FONT></STRONG></div></TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=1 cellPadding=3 width=1004 align=center bgColor=#999999 border=0>
<%
if menu<>"all" then
sql="select SFFamily.ID,SFFamily.Name,SFFamily.QQ,SFFamily.Addr,SFFamily.Peo,SFFamily.typeid,SFFamily.typename,SFFamily.About,SFFamily.content,SFFamily.Bulid,SFFamily.Master,SFFamily.Contact,SFFamily.Web,SFFamily.Addtime,SFFamily.Hits,SFFamily.ischeck,SFFamily.topic,SFFamily.xianlu,gametype.game"
sql=sql&" from SFFamily,Gametype where SFFamily.typeid="&menu
sql=sql&" SFFamily.ischeck=1 order by SFFamily.addtime desc"
else
sql="select SFFamily.ID,SFFamily.Name,SFFamily.QQ,SFFamily.Addr,SFFamily.Peo,SFFamily.typeid,SFFamily.typename,SFFamily.About,SFFamily.content,SFFamily.Bulid,SFFamily.Master,SFFamily.Contact,SFFamily.Web,SFFamily.Addtime,SFFamily.Hits,SFFamily.ischeck,SFFamily.topic,SFFamily.xianlu,gametype.game"
sql=sql&" from SFFamily,Gametype where"
sql=sql&" SFFamily.ischeck=1 order by SFFamily.addtime desc"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
rs.close
else
%>
<TABLE cellSpacing=1 cellPadding=3 width=1004 align=center bgColor=#999999
border=0>
<%do while not rs.eof%>
<tr bgcolor="#ffff11" onmouseover=javascript:this.bgColor='#FFFFFF' onmouseout=javascript:this.bgColor='#ffff11'>
<td width="107"> <a href="<%=rs("web")%>" target=_blank><%=rs("name")%></a></td>
<td width="117"> <%=rs("qq")%></td>
<td width="116"> <font color="#FF0000"><span class="style93"><span class="style49">
<%if rs("Bulid")<>"" then response.write year(rs("Bulid"))&"年"&month(rs("Bulid"))&"月"&day(rs("Bulid"))&"日"%>
</span></span></font></td>
<td width="75"><%=rs("Peo")%></td>
<td width="60"><%=rs("xianlu")%></td>
<td width="90"><%=rs("typename")%></td>
<td width="298"><%=rs("about")%></td>
<td width="84"><span class="font2"> <a href=sf_display.asp?id=<%=rs("id")%> target="_blank">点击查看</a></span><img src="image/ICON_New.gif" width="29" height="9"></td>
</tr>
<%
rs.movenext
loop
%>
</table>
<%
rs.close
end if
%>

SFFamily和Gametype两个表没有关联好
举个例子:
如果SFFamily里有一条记录
Gametype里有七条记录
则两个表关联以后的表就有七条记录,select 的结果就是七条
所以你遍历结果记录集显示的时候,就会显示七条
解决方法:
1. 重新关联两个表: From SFFamily, Gametype where SFFamily.X = Gametype.X;
2.或者Select Distinct 。。。选择唯一的数据