怎样用循环显示数据库内容在表格中,如显示在5行3列中?行列由纪录数来定?
<table>
<%do while not rs.eof%>
<tr><td><%=rs("content")%></td></tr><tr><td><%=rs("time")%></td></tr>
rs.movenext
<%loop%>
</table>
<table>
<%do while not rs.eof%>
<tr><td><%=rs("content")%></td></tr><tr><td><%=rs("time")%></td></tr>
<%rs.movenext
loop%>
</table>
sorry,写错了点了~~~
<table>
<%do while not rs.eof%>
<tr><td><%=rs("content")%></td></tr><tr><td><%=rs("time")%></td></tr>
<%rs.movenext
loop%>
</table>
<!--#include file="admin_conn.asp"-->
<%
adminrs.Open "Select country From address Order By ip",adminconn,1,1
%>
<table border=1>
<tr>
<%
For i=1 to adminrs.recordcount
If adminrs.EOF Then Exit For
%>
<td><%=adminrs("country")%></td>
<%
if i mod 5 = 0 then
response.write "</tr><tr>"
end if
adminrs.MoveNext
Next
adminrs.close
set adminrs=nothing
adminconn.close
set adminconn=nothing
%>
</tr></table>
你自己改改吧,关键是:if i mod 5 = 0 then