"" then
hwn=split(hw_name," ")
sera=sera&" and ( (1=1 "
for i=0 to ubound(hwn)
hwna=trim(hwn(i))
if hwna<>" " and hwna<>"" then
sera=sera&" and hw_name like '%"&hwna&"%'"
end if
next
sera=sera&" )"
if searchsn=1 then
sera=sera&" or (1=1"
for i=0 to ubound(hwn)
hwna=trim(hwn(i))
if hwna<>" " and hwna<>"" then
sera=sera&" and hw_sn like '%"&hwna&"%'"
end if
next
sera=sera&" )"
end if
if searchc1=1 then
sera=sera&" or (1=1"
for i=0 to ubound(hwn)
hwna=trim(hwn(i))
if hwna<>" " and hwna<>"" then
sera=sera&" and hw_content like '%"&hwna&"%'"
end if
next
sera=sera&" )"
end if
if searchc2=1 then
sera=sera&" or (1=1"
for i=0 to ubound(hwn)
hwna=trim(hwn(i))
if hwna<>" " and hwna<>"" then
sera=sera&" and hw_content2 like '%"&hwna&"%'"
end if
next
sera=sera&" )"
end if
if searchk=1 then
sera=sera&" or (1=1"
for i=0 to ubound(hwn)
hwna=trim(hwn(i))
if hwna<>" " and hwna<>"" then
sera=sera&" and hw_keyword like '%"&hwna&"%'"
end if
next
sera=sera&" )"
end if
sera=sera&" or (1=2) )"
showp=showp&"&hw_name="&hw_name
end if
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
showp=showp&"&price1="&price1
showp=showp&"&price2="&price2
if request("pagec")="" or Not(isNumeric(request("pagec"))) then
pagec=25
else
pagec=DelStr(request("pagec"))
end if
showp=showp&"&pagec="&pagec
sort_id=Request("sort_id")
if sort_id="" then sort_id=0
if not(isnumeric(sort_id)) then sort_id=0
if sort_id<1 then sort_id=0
sort_id=int(sort_id)
if sort_id<>0 then
chkid(sort_id)
sera=sera&" and sort_id=" & sort_id & ""
showp=showp&"&sort_id="&sort_id
end if
nsort_id=Request("nsort_id")
if nsort_id="" then nsort_id=0
if not(isnumeric(nsort_id)) then nsort_id=0
if nsort_id<1 then nsort_id=0
nsort_id=int(nsort_id)
if nsort_id<>0 then
chkid(nsort_id)
sera=sera&" and nsort_id=" & nsort_id & ""
end if
pinpai=request("pinpai")
if pinpai<>"" and pinpai<>0 then
chkid(pinpai)
sera=sera&" and pinpai_id=" & pinpai & ""
showp=showp&"&pinpai="&pinpai
end if
set rs=server.createobject("adodb.recordset")
sql="select hw_id,hw_name,hw_price1,hw_price2,hw_pic,hw_content from Baiyou_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&" order by "&orderx&""
rs.open sql,conn,1,1
if rs.eof then%>

你所选的类别没有商品

totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize
if request.form("hw_name")<>"" then
set rss=server.createobject("adodb.recordset")
sql="select * from Baiyou_search where search_name='"&hw_name&"'"
rss.open sql,conn,1,3
if rss.eof then
rss.addnew
rss("search_name")=hw_name
rss("hits")=1
else
rss("hits")=rss("hits")+1
end if
rss.update
rss.close
set rss=nothing
end if
%>