记录的显示问题
为什么从数据库引用的数据不连续显示,而是
logo
记录1
logo
记录2
logo
记录3
有几条记录就把LOGO显示了几次,好郁闷
<head>
<title> 欢迎留言 </title>
<link href= "style.css " rel= "stylesheet " type= "text/css ">
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 "> </head>
<body>
<table width= "881 " height= "681 " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 ">
<!--DWLayoutTable-->
<tr> ... </tr>
<tr> ... </tr>
<tr> <td height= "461 " valign= "top ">
<table width= "450 " border= "0 " cellpadding= "0 " cellspacing= "0 ">
<tr>
<td> <TABLE width=650 height= "87 " border=0 cellPadding=3 cellSpacing=1
bgColor=#c6d7c6 id=Table40>
<TR>
<TD colspan= "2 " bgColor=#f5faf5> <TABLE cellSpacing=0 cellPadding=0 width= "100% "
border=0>
<TR>
<TD width= "38% "> <P style= "MARGIN-TOP: 3px; MARGIN-LEFT: 10px "> <span class= "text1 " style= "font-weight: bold "> <%=rs( "user ")%> </span> 留言于 <%=rs( "data ")%> </P> </TD>
<TD width= "30% " align=left> 电话: <%=rs( "qq ")%> </TD>
<TD width= "32% " align=left> E-mail: <%=rs( "email ")%> </TD>
</TR>
</TABLE> </TD>
</TR>
<TR>
<TD width=50 bgColor=white> <P class= "text2 " style= "MARGIN-TOP: 3px; MARGIN-LEFT: 10px "> 内容: </p> </TD>
<TD width=385 bgColor=white> <P style= "MARGIN-TOP: 3px; MARGIN-LEFT: 10px "> <%=rs( "content ")%> </p> </TD>
</TR> <tr>
<td colspan= "2 " bgColor=#f5faf5 height= "20 " > </td>
</tr>
</TABLE> </td>
</tr>
<tr> <td>
<%
rs.movenext
loop
%>
</td> </tr>
<tr>
<td width= "330 " >
<div align= "right "> <a href= "add.asp "> 填写留言 </a>
<a href= "admin.asp "> 管理留言 </a> </div> </td>
</tr>
</table> </td> </tr>
<tr> 。。。 </tr>
<tr> 。。。 </tr>
</table>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
[解决办法]
你贴出来的代码不全,怎么帮你分析啊?
怎么记录集读取循环的开始代码都没有啊?
有Loop结束,怎么没有Do While开始啊?
[解决办法]
<%@LANGUAGE= "VBScript " codepage= "936 "%>
<!--#include file= "conn.asp "-->
<%
set rs=server.createobject( "adodb.recordset ")
sql= "select user,qq,email,content,data from main order by id desc "
rs.open sql,conn,1,1
%>
<head>
<title> 欢迎留言 </title>
<link href= "style.css " rel= "stylesheet " type= "text/css ">
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 "> </head>
<body>
<table width= "881 " height= "681 " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 ">
<!--DWLayoutTable-->
<tr> ... </tr>
<tr> ... </tr>
<tr> <td height= "461 " valign= "top ">
<table width= "450 " border= "0 " cellpadding= "0 " cellspacing= "0 ">
<tr>
<td>
<%do while not rs.eof%>
<TABLE width=650 height= "87 " border=0 cellPadding=3 cellSpacing=1
bgColor=#c6d7c6 id=Table40>
<TR>
<TD colspan= "2 " bgColor=#f5faf5> <TABLE cellSpacing=0 cellPadding=0 width= "100% "
border=0>
<TR>
<TD width= "38% "> <P style= "MARGIN-TOP: 3px; MARGIN-LEFT: 10px "> <span class= "text1 " style= "font-weight: bold "> <%=rs( "user ")%> </span> 留言于 <%=rs( "data ")%> </P> </TD>
<TD width= "30% " align=left> 电话: <%=rs( "qq ")%> </TD>
<TD width= "32% " align=left> E-mail: <%=rs( "email ")%> </TD>
</TR>
</TABLE> </TD>
</TR>
<TR>
<TD width=50 bgColor=white> <P class= "text2 " style= "MARGIN-TOP: 3px; MARGIN-LEFT: 10px "> 内容: </p> </TD>
<TD width=385 bgColor=white> <P style= "MARGIN-TOP: 3px; MARGIN-LEFT: 10px "> <%=rs( "content ")%> </p> </TD>
</TR> <tr>
<td colspan= "2 " bgColor=#f5faf5 height= "20 " > </td>
</tr>
</TABLE> </td>
</tr>
<tr> <td>
<%
rs.movenext
loop
%>
</td> </tr>
<tr>
<td width= "330 " >
<div align= "right "> <a href= "add.asp "> 填写留言 </a>
<a href= "admin.asp "> 管理留言 </a> </div> </td>
</tr>
</table>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</td> </tr>
<tr> 。。。 </tr>
<tr> 。。。 </tr>
</table>
</body>
</html>