给你一个分页代码
<%
set rs=server.createobject("adodb.recordset")
sql="select * from shop_snsn order by shopid desc"
rs.open sql,conn,1,1
if rs.eof then
response.write ("没有资料")
else
%>
<%
page=clng(request("page"))
rs.pagesize=50
if page="" or page<1 then
page=1
end if
if page>rs.pagecount then
page=rs.pagecount
end if
if rs.pagecount>0 then
rs.absolutepage=page
end if
for i=1 to rs.pagesize
%>
<%rs.movenext%>
<%
if rs.eof then
exit for
end if
%>
<%next%>
[首页] | [上一页] | [下一页] | [末页] | [第<%=page%>页] | [共<%=rs.pagecount%>页] | [共<%=rs.recordcount%>商品] |
" '查询数据开始 response.write "" response.write "" '查询数据结束 response.write " | "
搂主很粗心.呵呵.你提取的是p但是你传的却是page
<%
If Len(Trim(Request("page")))=0 Then '返回目标页码的判断
page=1
Else
page=CInt(Trim(Request("page")))
End if
set rs=Server.CreateObject("ADODB.RecordSet")
If Request("o")="3" then
sql="select * from info where ClassID_id='"&request("d")&"' and check=1 order by pr asc"
ElseIf Request("o")="4" then
sql="select * from info where ClassID_id='"&request("d")&"' and check=1 order by alexa desc"
Else
sql="select * from info where ClassID_id='"&request("d")&"' and check=1 order by infoid asc"
end if
rs.open sql,conn,1,1
rs.PageSize=10
If rs.bof and rs.eof then
response.write "
结果页码: <% If page <>1 then Response.Write "首页 " end if tmppage = page - 1 If tmppage <= 0 then tmppage = 1 else Response.Write"上一页" end if tmppage = page + 1 If tmppage >rs.PageCount then tmppage = page else Response.Write " 下一页 " end If If Cstr(page) <> Cstr(rs.PageCount) and Cstr(rs.PageCount) <> 0 then Response.Write "尾页" end if Response.Write " "&rs.RecordCount&" 条记录 " If Cstr(rs.PageCount) <> 0 then Response.Write "" & page & " / "&rs.PageCount&"页" end if rs.close set rs=nothing %> |