28,409
社区成员




<%
sql="SELECT * FROM rzhi ORDER BY ID DESC"
set rs=Server.CreateObject("Adodb.Recordset")
rs.open sql,conn,1,3
if not rs.eof then
pagesUrl="?"
pagesSize=5
if request("page")="" then
thisPage=1
else
thisPage=cint(request("page"))
end if
rs.pagesize=pagesSize
rs.absolutepage=thisPage
allPages=rs.pagecount
allRecords=rs.recordcount
do while not rs.eof
i=i+1
%>
<a href="kan_rzhi.asp?id=<%=rs("id")%>"><%=rs("r_biaoti")%></a>
<%
if i>=pagesSize then exit do
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
<%
if allPages > 0 then
response.write "当前页<font color='red'>"&thisPage&"</font>/<font color='red'>"&allPages&"</font>, 共<font color='#ff0000'>"&allRecords&"</font>条记录, 每页<font color='red'>"&pagesSize&"</font>条"
if thisPage<=1 then
response.write " 首页 上一页 "
else
response.write " <a href="""&pagesUrl&"page=1"">首页</a> <a href="""&pagesUrl&"page="&(thisPage-1)&""">上一页</a> "
end if
if thisPage>=allPages then
response.write " 下一页 尾页 "
else
response.write " <a href="""&pagesUrl&"page="&(thisPage+1)&""">下一页</a> <a href="""&pagesUrl&"page="&allPages&""">尾页</a> "
end if
response.write "</select>"
end if
%>
</td>
</tr>
</table></td>
<td width="71" height="290"></td>
<td width="187" height="290" align="left" valign="top" class="table11"><table width="197" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="187" height="290" align="left" valign="top" bordercolor="2">
<%
sql="SELECT * FROM ge ORDER BY ID DESC"
set rs=Server.CreateObject("Adodb.Recordset")
rs.open sql,conn,1,3
if not rs.eof then
pagesUrl="?"
pagesSize=5
if request("page")="" then
thisPage=1
else
thisPage=cint(request("page"))
end if
rs.pagesize=pagesSize
rs.absolutepage=thisPage
allPages=rs.pagecount
allRecords=rs.recordcount
do while not rs.eof
i=i+1
%>
<a href="bofang.asp?id=<%=rs("id")%>"><%rs=("name")%></a>
<%
if i>=pagesSize then exit do
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
<%
if allPages > 0 then
response.write "当前页<font color='red'>"&thisPage&"</font>/<font color='red'>"&allPages&"</font>, 共<font color='#ff0000'>"&allRecords&"</font>条记录, 每页<font color='red'>"&pagesSize&"</font>条"
if thisPage<=1 then
response.write " 首页 上一页 "
else
response.write " <a href="""&pagesUrl&"page=1"">首页</a> <a href="""&pagesUrl&"page="&(thisPage-1)&""">上一页</a> "
end if
if thisPage>=allPages then
response.write " 下一页 尾页 "
else
response.write " <a href="""&pagesUrl&"page="&(thisPage+1)&""">下一页</a> <a href="""&pagesUrl&"page="&allPages&""">尾页</a> "
end if
response.write "</select>"
end if
%>
do while not rs.eof
i=i+1 '這句的位置放錯了,這裏設為 i=0
'加在這裏
i=i+1
if i>=pagesSize then exit do
rs.movenext
loop