%
if not isempty(request("pageno")) or request("pageno")<>0 then
pageno=request.querystring("pageno")
else
pageno=1
end if
if request("sort_id") <> "" then '大类别
sort_id=request("sort_id")
else
sort_id=0
end if
if request("Nsort_id") <> "" then '小类别
Nsort_id=request("Nsort_id")
else
Nsort_id=0
end if
%>
<%
Set rs = Server.CreateObject("ADODB.RecordSet")
if sort_id <> 0 and Nsort_id <> 0 then
sql="select * from hw where sort_id="&sort_id&" and Nsort_id="&Nsort_id&" Order By hw_id DESC"
rs.Open sql,conn,1,1
elseif sort_id <> 0 and Nsort_id = 0 then
sql="select * from hw where sort_id="&sort_id&" Order By hw_id DESC"
rs.Open sql,conn,1,1
elseif sort_id = 0 and Nsort_id = 0 then
sql="select * from hw Order By hw_id DESC"
rs.Open sql,conn,1,1
else
sql="select * from hw where Nsort_id="&Nsort_id&" Order By hw_id DESC"
rs.Open sql,conn,1,1
end if
if not rs.eof then
page=9
rs.pagesize=page
maxpage=rs.pagecount
if pageno < 1 then
pageno =1
end if
if pageno+1 >maxpage+1 then
pageno=maxpage
end if
rs.absolutePage=pageno
else
maxpage=1
end if
total = rs.RecordCount
%>