% const MaxPerPage=20
typeid=4
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
dim sql
dim rs
dim rstype
dim typesql
dim typeid,typename1
'if not isEmpty(request("typeid")) then
'typeid=request("typeid")
'else
'typeid=1
' end if
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
sql1="select * from type where typeid="&typeid
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,conn,1,1
sqlconfig="select * from config"
set rsconfig=server.createobject("adodb.recordset")
rsconfig.open sqlconfig,conn,1,1
footer=""
footer=footer&"
<%
sql="select * from article where typeid="+cstr(typeid)+" order by newsid desc"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "
暂无任何文章记录!
"
else
totalPut=rs.recordcount
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showContent
showpage totalput,MaxPerPage,"mywine.html"
else
if (currentPage-1)*MaxPerPage
<% i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
<%end sub
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
response.write "
"
response.write "共 "&totalnumber&" 条记录"
response.write " 页次:"&CurrentPage&"/"&n&"页 每页"&maxperpage&"条"
if CurrentPage<2 then
response.write "【最前页】【上一页】"
else
response.write "【最前页】"
response.write "【上一页】"
end if
if n-currentpage<1 then
response.write "【下一页】【最后页】"
else
response.write ""
response.write "【下一页】【最后页】"
end if
response.write "