%
Sub LastNextPage(pagecount,page,resultcount)
Dim query, a, x, temp
action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME")
query = Split(Request.ServerVariables("QUERY_STRING"), "&")
For Each x In query
a = Split(x, "=")
If StrComp(a(0), "page", vbTextCompare) <> 0 Then
temp = temp & a(0) & "=" & a(1) & "&"
End If
Next
if page<=1 then
Response.Write ("首页 " & vbCrLf)
Response.Write ("上一页 " & vbCrLf)
else
Response.Write("首页 " & vbCrLf)
Response.Write("上一页 " & vbCrLf)
end if
if page>=pagecount then
Response.Write ("下一页 " & vbCrLf)
Response.Write ("尾页 " & vbCrLf)
else
Response.Write("下一页 " & vbCrLf)
Response.Write("尾页 " & vbCrLf)
end if
Response.Write("共" & pageCount & "页" & vbCrLf)
Response.Write(" " & resultcount & "条信息" & vbCrLf)
End Sub
%>
<%
cid=cint(request("cid"))
if cid=0 then cid=1
select case cid
case 1
cid="(Article_cateId=1 or Article_ammounce=true)"
list_titel="留言板"
titel="留言板"
case 3
end select
%>
<%
set rs=server.CreateObject("adodb.recordset")
temp=1
Ssql="select * from Book where pass=true order by time desc,id desc"
rs.open Ssql,conn,1,1
if not rs.eof then
rs.PageSize =8 '每页记录条数
result_num=rs.RecordCount '记录总数
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
else
result_num=0
maxpage=0
page=0
end if
if not rs.eof then
for i=1 to rs.PageSize
%>
" >
<%=rs("users")%>
邮箱:<%=rs("email")%> QQ号:<%=rs("oicq")%>
<%=HTMLEncode(rs("content"))%>
<% if rs("repcontent")<>"" then%>
老师回复:
<%=rs("repcontent")%>
<% end if%>
<%
rs.movenext
if rs.EOF then Exit For
next
end if
rs.close
%>