Question

.怎么将以上表格循环4行，我用的是asp

<!--#include file="conn.asp" -->
<% set rs=server.CreateObject("adodb.recordset")
Sql="select * from a order by id desc"
Rs.Open Sql,Conn,1,1
%>
<table border="1" cellspacing="1" cellpadding="1">

<tr>
<%for i=1 to 4%>
<td><%=rs("a")%></td>
<%rs.movenext
next%>
</tr>

</table>

.怎么将以上表格循环4行，我用的是asp

Answer 1

<!--#include file="conn.asp" -->
<% set rs=server.CreateObject("adodb.recordset")
Sql="select * from a order by id desc"
Rs.Open Sql,Conn,1,1%>
<table border="1" cellspacing="1" cellpadding="1">
<%for i=1 to 4
if rs.eof then exit for%>
<tr><td><%=rs("a")%></td></tr>
<%rs.movenext
next%>
</table>

Answer 2

如果是行的话应该是这样：
<%
for i=1 to rs.recordCount ’变量i从1循环到数据库中的全部记录数
if (i mod 4 =1) then ’每个tr显示4个记录,可根据需要自行修改
response.write "<tr>"
end if
response.write "<td>"&rs("a")&"</td>"
if (i mod 4 = 0) then
response.write "</tr>"
end if
rs.movenext
next
rs.close
%>