inph.asp

asp网站 挺不错的 试一下吧 网上购物系统 呵呵呵

<table cellSpacing="0" cellPadding="0" border="0" width="171">
<tr><td height="3"></td></tr><tr><td><img src="Skin/<%=venshop_skin%>/inph1.gif" width="171" height="48"></td></tr><tr><td background="Skin/<%=venshop_skin%>/inphbg.gif" align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<%set rs=server.createobject("adodb.recordset")
if nsort_id<>"" then
sql="select top 10 * from venshop_hw where hw_kucun>0 and nsort_id="&nsort_id&" order by hw_buys DESC,hw_id DESC"
elseif sort_id<>"" then
sql="select top 10 * from venshop_hw where hw_kucun>0 and sort_id="&sort_id&" order by hw_buys DESC,hw_id DESC"
else
sql="select top 10 * from venshop_hw where hw_kucun>0 order by hw_buys DESC,hw_id DESC"
end if
  rs.open sql,conn,1,1
  if rs.eof then
  response.write "<tr><td height=26 colspan=3 align=center>抱歉,该类暂无商品</td></tr>"
  else
  do while not rs.eof%><tr><td height="26" width="8"></td>
<td height="26"><a href="views.asp?hw_id=<%=rs("hw_id")%>" target=_blank><%=rs("hw_name")%></a><font color="#FF0000">￥<%=rs("hw_price2")%></font></td><td height="26" width="8"></td></tr>
<%
rs.movenext
loop
end if
rs.close
set rs=nothing%></table></td></tr><tr><td><img src="Skin/<%=venshop_skin%>/inph2.gif" width="171" height="9"></a></td></tr></table>