分页问题
现在这段代码能分页 但是他所分出的页和我数据库里的内容不一样 错在那了 应该怎么改啊 兄弟们!!!<!--#include file="conn.asp"-->
<%
set ztrs=server.CreateObject("adodb.recordset")
ztrs.open"select * from zhutlq",conn,1,1
page=request("page")
ztrs.pagesize=3
if page="" or page<1 then
page=1
else
page=cint(page)
end if
if page>ztrs.pagecount then
page=ztrs.pagecount
else
page=cint(page)
end if
if not ztrs.eof then
ztrs.absolutepage=page
for i=1 to ztrs.pagesize
if ztrs.eof then exit for
next %>
<tr>
<td width="83" height="30" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="83" height="30" valign="top"><%=ztrs("status")%></td>
</tr>
</table></td>
<td width="560" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="560" height="30" valign="top"><a href='tlq.asp?boardid=<%=ztrs("boardid")%>'><%=ztrs("tlqname")%></a></td>
</tr>
</table></td>
<td width="137" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="137" height="30" valign="top"><%=ztrs("post")%></td>
</tr>
</table></td>
</tr>
<%
ztrs.movenext
end if
ztrs.close
set ztrs=nothing
%>
</table>