求个算法
<%i=1
set showbbs=conn.execute("select*from liuyan")
do while not showbbs.eof
%>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; " bordercolor="#000000" width="100%" height="20">
<tr>
<td width="30%"><%=showbbs("username")%> </td>
<td width="10%"></td>
<td width="60%">
<a href="show.asp?id=<%=showbbs("id")%>"><%=showbbs("title")%></a></td>
</tr>
</table>
</center>
</div><hr size="1">
<%i=i+1
if i>16 then exit do
showbbs.movenext
Loop
showbbs.Close
set showbbs=nothing
%>
让以上代码只显示数据中的后16个记录
要怎么做
问题点数：20、回复次数：3Top
1 楼iuhxq（小灰）回复于 2004-11-02 10:54:03 得分 10
set rs=conn.execute("select top 16 * from liuyan order by id desc")
while not rs.eof
response.write rs("fds")
rs.movenext
wendTop
2 楼wsdzmhongm（丁丁）回复于 2004-11-02 10:56:32 得分 10
rs.movelast
rs.move -16Top
3 楼chenxuchen（）回复于 2004-11-02 11:02:18 得分 0
rs,movelast
i=1
do while not showbbs.bof
if i>16 then exit do
读取数据操作
i=i+1
showbbs.moveprevious
loop
Top
