www.gusucode.com > 运动用品商城网站系统源代码程序 > 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_price3,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=lookpage totalrec=rs.recordcount totalpage=rs.pagecount if page>totalpage then page=totalpage rs.absolutepage=page rs.cachesize=rs.pagesize%> <tr><td class="sort"> <IMG src="Skin/<%=venshop_skin%>/home.gif" border=0 align="absmiddle"> 您的位置: <a href="index.asp">首页</a> >> <%=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"--> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr><td height="23" class="sortb"> <p style="line-height: 150%; margin: 5px">第<%=page%>页/共<%=totalpage%>页 <%if page-1>0 then%><a href="<%=filename%>?page=<%=page-1%>&stype=<%=request("stype")%>">上一页</a> <%else%>上一页 <%end if%> <%if page+1<=totalpage then%> <a href="<%=filename%>?page=<%=page+1%>&stype=<%=request("stype")%>">下一页</a> <%else%> 下一页 <%end if%> <br>选择页数:<%for i=1 to totalpage if i=page then%> <font color="#FF0000"><b><%=i%></b></font> <%else%> <a href="<%=filename%>?page=<%=i%>&stype=<%=request("stype")%>"><%=i%></a> <%end if next%></td></tr></table> </td></tr> <%end if rs.close set rs=nothing%></table> </td></tr></table></div> <!--#include file="IncAsp/venshop_copy.asp"-->