我想把下面这段改成每行3列显示 循环..........

<%
sql="select top 1 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"
set rs=conn.execute(sql)
if not Rs.eof then
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><img src="uppic/<%=trim(rs("firstImageName"))%>" width="150" height="180" border="0"></a></td>
</tr>
<tr>
<td height="25" align="center"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><%=left(rs("title"),12)%></a></td>
</tr>
</table>
<%
else
response.write "<tr><td align=center colspan=2 bgcolor=#E8E8F4>尚无收录</td></tr>"
end if
rs.close
set conn=nothing
%>

你就SELECT了一个记录，怎么循环啊？

那还需要些什么?

sql="select top 1 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"

改成吧：
sql="select * from NEWS where firstImageName<>'' and ok=true order by ID DESC"

改了之后又怎么做？

http://www.bc-cn.net/bbs/dispbbs.asp?BoardID=10&ID=32392&replyID=&skin=0

显示前三条记录!
这样改:
sql="select top 3 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"

帮我改一改``
我还不是很明白``

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<%
sql="select * from NEWS where firstImageName<>'' and ok=true order by ID DESC"
set rs=conn.execute(sql)
i=1
if not Rs.eof then
do while not rs.eof%>
<td><table width="33%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><img src="uppic/<%=trim(rs("firstImageName"))%>" width="150" height="180" border="0"></a></td>
</tr>
<tr>
<td height="25" align="center"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><%=left(rs("title"),12)%></a></td>
</tr>
</table>
<%
if i mod 3 = 0 then response.write("</tr><tr>")
rs.movenext
i=i+1
loop
%>
</tr></table>
<%else
response.write "<tr><td align=center colspan=2 bgcolor=#E8E8F4>尚无收录</td></tr>"
end if
rs.close
set conn=nothing
%>

谢谢各位``现在可以了``