<% if request("action")="search" then 'venshopcom="qbhf>sfrvftu)#qbhf#*|jg!qbhf>##!uifo!qbhf>2|jg!opu)jtovnfsjd)qbhf**!uifo!qbhf>2|jg!qbhf=2!uifo!qbhf>2|qbhf>jou)qbhf*|ix`obnf>sfrvftu)#ix`obnf#*|qsjdf2>EfmTus)sfrvftu)#qsjdf2#**|jg!qsjdf2>##!ps!opu)jtovnfsjd)qsjdf2**!uifo!qsjdf2>1|qsjdf3>EfmTus)sfrvftu)#qsjdf3#**|jg!qsjdf3>##!ps!opu)jtovnfsjd)qsjdf3**!uifo!qsjdf3>2111111111|jg!sfrvftu)#qjoqbj#*=?#1#!uifo|qjoqbj>EfmTus)sfrvftu)#qjoqbj#**|foe!jg|rvfivp>EfmTus)sfrvftu)#rvfivp#**|jg!sfrvftu)#psefs#*=?##!uifo!|psefs>EfmTus)sfrvftu)#psefs#**|fmtf|psefs>#yv#|foe!jg|jg!psefs>#ujnf#!uifo|psefsy>#ix`je!eftd#|fmtfjg!psefs>#ipu#!uifo|psefsy>#ix`cvzt!eftd-ix`je!eftd#|fmtfjg!psefs>#qsjdf2#!uifo|psefsy>#usjn)ix`qsjdf3*!btd#|fmtfjg!psefs>#qsjdf2#!uifo|psefsy>#usjn)ix`qsjdf3*!eftd#|fmtf|psefsy>#ix`yv!eftd#|foe!jg|jg!sfrvftu)#qbhfd#*>##!ps!Opu)jtOvnfsjd)sfrvftu)#qbhfd#***!uifo|!!!qbhfd>36|fmtf|!!!qbhfd>EfmTus)sfrvftu)#qbhfd#**|foe!jg|jg!ix`obnf=?##!uifo|ixo>tqmju)ix`obnf-#!#*|gps!j>1!up!vcpvoe)ixo*|ixob>usjn)ixo)j**|jg!ixob=?#!#!boe!ixob=?##!uifo|tfu!st>tfswfs/dsfbufpckfdu)#bepec/sfdpsetfu#*|trm>#tfmfdu!+!gspn!wfotipq`tfbsdi!xifsf!tfbsdi`obnf>(#'ixob'#(#|st/pqfo!trm-dpoo-2-4|jg!st/fpg!uifo|st/beeofx|st)#tfbsdi`obnf#*>ixob|st)#ijut#*>2|fmtf|st)#ijut#*>st)#ijut#*,2|foe!jg|st/vqebuf|st/dmptf|tfu!st>opuijoh|foe!jg|ofyu|foe!jg|jg!tpsu`je=?##!boe!tpsu`je=?1!boe!jtOvnfsjd)tpsu`je*!uifo!tfsb>#!boe!tpsu`je>#!'!tpsu`je!'!##|jg!ix`obnf=?##!uifo|tfsc>##|ixo>tqmju)ix`obnf-#!#*|gps!j>1!up!vcpvoe)ixo*|ixob>usjn)ixo)j**|jg!ixob=?#!#!boe!ixob=?##!uifo|tfsc>tfsc'#!boe!ix`obnf!mjlf!(&#'ixob'#&(#|foe!jg|ofyu|foe!jg|jg!qjoqbj=?##!uifo!tfsd>#!boe!qjoqbj`je!mjlf!(&#!'!qjoqbj!'!#&(#|tfse>#!boe!ix`lvdvo?1#" 'execute(vencode(venshopcom)) page=request("page") if page="" then page=1 if not(isnumeric(page)) then page=1 if page<1 then page=1 page=int(page) hw_name=request("hw_name") price1=DelStr(request("price1")) if price1="" or not(isnumeric(price1)) then price1=0 price2=DelStr(request("price2")) if price2="" or not(isnumeric(price2)) then price2=1000000000 if request("pinpai")<>"0" then pinpai=DelStr(request("pinpai")) end if quehuo=DelStr(request("quehuo")) if request("order")<>"" then order=DelStr(request("order")) else order="xu" end if if order="time" then orderx="hw_id desc" elseif order="hot" then orderx="hw_buys desc,hw_id desc" elseif order="price1" then orderx="trim(hw_price2) asc" elseif order="price1" then orderx="trim(hw_price2) desc" else orderx="hw_xu desc" end if if request("pagec")="" or Not(isNumeric(request("pagec"))) then pagec=25 else pagec=DelStr(request("pagec")) end if if hw_name<>"" then hwn=split(hw_name," ") for i=0 to ubound(hwn) hwna=trim(hwn(i)) if hwna<>" " and hwna<>"" then set rs=server.createobject("adodb.recordset") sql="select * from norshop_search where search_name='"&hwna&"'" rs.open sql,conn,1,3 if rs.eof then rs.addnew rs("search_name")=hwna rs("hits")=1 else rs("hits")=rs("hits")+1 end if rs.update rs.close set rs=nothing end if next end if if sort_id<>"" and sort_id<>0 and isNumeric(sort_id) then sera=" and sort_id=" & sort_id & "" if hw_name<>"" then serb="" hwn=split(hw_name," ") for i=0 to ubound(hwn) hwna=trim(hwn(i)) if hwna<>" " and hwna<>"" then serb=serb&" and hw_name like '%"&hwna&"%'" end if next end if if pinpai<>"" then serc=" and pinpai_id like '%" & pinpai & "%'" serd=" and hw_kucun>0" set rs=server.createobject("adodb.recordset") sql="select * from norshop_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&serb&serc&serd&" order by "&orderx&"" rs.open sql,conn,1,1 if rs.eof then%><%else rs.pagesize=pagec totalrec=rs.recordcount totalpage=rs.pagecount if page>totalpage then page=totalpage rs.absolutepage=page rs.cachesize=rs.pagesize%> &price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>" method=post> <%end if%><% rs.close set rs=nothing end if%>
你所选的类别没有商品
  共<%=totalrec%>件商品,这是第<%=(page-1)*rs.pagesize+1%>-<%if page+1<=totalpage then%><%=page*rs.pagesize%><%else%><%=totalrec%><%end if%>件
<%if lookt="image" then i=0 do while not rs.eof and (i<%rs.movenext loop else%><%i=0 do while not rs.eof and (i <%if (i mod lookhang=0) and i>=lookhang then%><%end if rs.movenext loop%><%end if%>

第<%=page%>页/共<%=totalpage%>页   <%if page-1>0 then%>&price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>">上一页<%else%>上一页<%end if%>   <%if page+1<=totalpage then%> &price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>">下一页<%else%>下一页<%end if%>   页面跳转:
选择页数:<%for i=1 to totalpage if i=page then%> <%=i%> <%else%> &price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>"><%=i%> <%end if next%>

关键字: ">
选择分类:<%set rs=server.createobject("adodb.recordset") rs.open "select * from norshop_sort order by sort_id DESC",conn,1,1%>
选择品牌: <%set rs=server.createobject("adodb.recordset") rs.open "select * from norshop_pinpai order by pinpai_id DESC",conn,1,1%>
价格范围: "> - ">
热门搜索:<%set rs=server.createobject("adodb.recordset") sql="select top 10 * from norshop_search order by hits desc" rs.open sql,conn,1,1 if rs.eof then response.write "没有数据" else do while not rs.eof%>"><%=rs("search_name")%>, <%rs.movenext loop end if rs.close set rs=nothing %>
排列方式:
每页数量: