<%if request("typeid")=3 then
set rs=server.CreateObject("adodb.recordset")
rs.open "select cdkey88_news.*,cdkey88_game.game_name from cdkey88_news,cdkey88_game where cdkey88_news.game_id=cdkey88_game.game_id and ( cdkey88_news.news_title like '%"&request("keywords")&"%' or cdkey88_news.news_content like '%"&request("keywords")&"%' or cdkey88_game.game_name like '%"&request("keywords")&"%') order by cdkey88_news.news_id desc",conn,1,1
%>
<%
if rs.eof then
response.write"对不起,没有找到相关记录! | "
end if
if rs.recordcount<>0 then
rs.pagesize=20
if request("page")<>"" then
currentpage=cint(request("page"))
else
currentpage=1
end if
if currentpage<=1 then
currentpage=1
end if
if currentpage=>rs.pagecount then
currentpage=rs.pagecount
end if
rs.AbsolutePage=currentpage
end if
do while not rs.eof
%>
|
|
|
<%i1=i1+1
if i1>=rs.pagesize then exit do
rs.movenext
loop
%>
第<%=currentpage%>页/共<%=rs.PageCount%>页 共有<%=rs.recordcount%>条记录
<% 'if session("cur_page")>1 then %>
&typeid=<%=request("typeid")%>">首页
&typeid=<%=request("typeid")%>">上一页
<% 'end if%>
<% 'if session("cur_page")
&typeid=<%=request("typeid")%>">下一页
&typeid=<%=request("typeid")%>">末页
<% 'end if %> |
|