| <%
set rs=server.createobject("ADODB.Recordset")
sql="select * from P_info where p_other = 0 "
classType = request("classType")
smallclass = request("smallclass")
key = request("key")
if classType <> "" then
sql = sql & " and p_type = '"&classType&"'"
end if
if smallclass <> "" then
sql = sql & " and p_small_type = '"&smallclass&"'"
end if
if key <> "" then
sql = sql & " and p_name like '%"&key&"%'"
end if
sql = sql & " order by p_id desc"
rs.open sql,conn,1,1
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
%>
<%
rs.close
set rs=nothing
%>
|
