首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > ASP >

记录的显示有关问题

2012-02-29 
记录的显示问题为什么从数据库引用的数据不连续显示,而是logo记录1logo记录2logo记录3有几条记录就把LOGO

记录的显示问题
为什么从数据库引用的数据不连续显示,而是
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> &nbsp;留言于&nbsp; <%=rs( "data ")%> </P> </TD>
                                    <TD   width= "30% "   align=left> 电话:&nbsp; <%=rs( "qq ")%> &nbsp; </TD>
                                    <TD   width= "32% "   align=left> &nbsp;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> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <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> &nbsp;留言于&nbsp; <%=rs( "data ")%> </P> </TD>
<TD width= "30% " align=left> 电话:&nbsp; <%=rs( "qq ")%> &nbsp; </TD>
<TD width= "32% " align=left> &nbsp;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> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<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>

热点排行