<%
P_id=request("p_id")
Keyword=request("keyword")
set rs=server.createobject("adodb.recordset")
if keyword="" then
if p_id="" then
rs.open "select * from manage_pro order by id desc",conn,1,1
else
rs.open "select * from manage_pro where p_id="&p_id&" order by id desc",conn,1,1
end if
else
if p_id="" then
rs.open "select * from manage_pro where title like '%"&keyword&"%' order by id desc",conn,1,1
else
rs.open "select * from manage_pro where p_id="&p_id&" and title like '%"&keyword&"%' order by id desc",conn,1,1
end if
end if
dim page
rs.pagesize=12
page=request.querystring("page")
if page = "" or IsNull(page) then page = 1
if not IsNumeric(page) then page = 1
if request("page")<>"" then
page=cint(request("page"))
end if
if page < 1 then
page = 1
elseif page > rs.pagecount then
page = rs.pagecount
end if
if not rs.EOF and not rs.bof then
rs.absolutepage=page
end if
count=rs.pagesize
%>
<%if p_id<>"" and keyword="" then%>
<%elseif keyword<>"" then%>
<% end if %>
|