new.asp

凡人网络购物系统 v8.0 中文版

<!--#include file="conn.asp"-->
<%web="http://"&Request.ServerVariables("SERVER_NAME")&replace(Request.ServerVariables("script_name"),"/new.asp","")
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_id<>0 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('<table border=0 cellpadding=2 cellspacing=0 width=100% align=center>');<%do while not rs.eof%>
document.write('<tr><td height=20><a href=<%=web%>/views.asp?hw_id=<%=rs("hw_id")%> target=_blank><%=icon%><%=rs("hw_name")%></a></td></tr>');<%rs.movenext  
loop  
rs.close
set rs=nothing%>
document.write('</table>');