sort_id=request("sort_id")
tjindex=request("tjindex")
tjsort=request("tjsort")
tejia=request("tejia")
pagec=request("pagec")
icon=request("icon")
order=request("order")
if pagec="" or Not(isNumeric(pagec)) then pagec=10
if icon="" then icon="·"
if order="hot" then
order="hw_buys"
else
order="hw_id"
end if
if sort_id"" and sort_id0 and isNumeric(sort_id) then sera=" and sort_id=" & sort_id & ""
if tjindex=1 then serb=" and tjindex=1"
if tejia=1 then serc=" and tejia=1"
if tjsort=1 then serd=" and tjsort=1"
set rs=server.createobject("adodb.recordset")
sql="select top "&pagec&" * from venshop_hw where hw_kucun>0 "&sera&serb&serc&serd&" order by "&order&" desc,hw_id desc"
rs.open sql,conn,1,1%>document.write('');
document.write(''); loop
rs.close
set rs=nothing%>
document.write('');