www.gusucode.com > 凡人网络购物系统 2008源码程序 > hot.asp

    <!--#include file="conn.asp"-->
<!--#include file="IncAsp/venshop_top.asp"-->
<div align="center">
<table cellpadding="0" cellspacing="0" class="all_t1">
<tr><td class="all_l_td" valign="top">
<!--#include file="IncAsp/venshop_log.asp"--><div class="d5"></div><!--#include file="IncAsp/venshop_sort.asp"--><div class="d5"></div>
</td>
<td valign="top" class="all_c_td">
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<%
if request("stype")="tjindex" then
serd=" and tjindex=1"
sn="推荐商品"
elseif request("stype")="tejia" then
sere=" and tejia=1"
sn="特价商品"
elseif request("stype")="tjsort" then
serf=" and tjsort=1"
sn="分类推荐商品"
elseif request("stype")="hot" then
order="hot"
sn="热卖商品"
else
sn="最新商品"
end if
order=request("order")
page=request("page")
page=getpage(page)
order=getorder(order)
set rs=server.createobject("adodb.recordset")
sql="select hw_id,hw_name,hw_price1,hw_price2,hw_pic,hw_content from venshop_hw where hw_kucun>0 " &serd&sere&serf&"  order by "&order&""
rs.open sql,conn,1,1
if rs.eof then%>
<tr><td align="center" height="30">你所选的类别没有商品</td></tr>
<%else
rs.pagesize=50
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize%>
<tr><td class="sort">&nbsp;<IMG src="Skin/<%=venshop_skin%>/home.gif" border=0 align="absmiddle"> 您的位置:  
	<a href="index.asp">首页</a> >>&nbsp;<%=sn%>
</td></tr>
<tr><td height=5></td></tr>
<tr><td width="100%" align="center" style="border: 1px solid #E1E1E1">
<!--#include file="IncAsp/venshop_ins.asp"-->
</td></tr>
<%end if
rs.close
set rs=nothing%></table>
</td></tr></table></div>
<!--#include file="IncAsp/venshop_copy.asp"-->