|
|
<%
keyword1=request("keyword1")
set rs2=server.createobject("adodb.recordset")
sql="select * from prod where uname like '%"&keyword1&"%' order by id desc"
rs2.open sql,conn,1,1
rs2.pagesize=20
curpage=request("curpage")
if not rs2.eof then
rs2.movefirst
if trim(request("curpage"))="" then
curpage=1
else
curpage=Cint(request("curpage"))
end if
if curpage>rs2.pagecount then
curpage=rs2.pagecount
end if
rs2.AbsolutePage=CurPage
end if
%>
|
|
|