www.gusucode.com > 运动用品商城网站系统源代码程序 > sortid11.asp
<% sort_id=11 chkid(sort_id) set rs=server.createobject("adodb.recordset") sql="select sort_name,sort_skin from venshop_sort where sort_id="&sort_id&"" rs.open sql,conn,1,1 if not rs.eof then sort_name=rs("sort_name") if rs("sort_skin")<>"" then venshop_skin=rs("sort_skin") end if rs.close set rs=nothing order=request("order") page=request("page") orderx=getorder(order) page=getpage(page) %> <div align="center"> <table cellpadding="0" cellspacing="0"> <tr><td valign="top"> </td> <td valign="top"> <table border="0" cellpadding="0" cellspacing="0"> <% set rs=server.createobject("adodb.recordset") sql="select banner,url from venshop_logo where sort="&sort_id&"" rs.open sql,conn,1,1 do while not rs.eof%> <%rs.movenext loop rs.close set rs=nothing%> <%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 and sort_id="&sort_id&" order by "&orderx&"" rs.open sql,conn,1,1 if rs.eof then%><tr><td align="center" height="30">你所选的类别没有商品</td></tr> <%else rs.pagesize=8 totalrec=rs.recordcount totalpage=rs.pagecount if page>totalpage then page=totalpage rs.absolutepage=page rs.cachesize=rs.pagesize%> <tr><td height=5> </td></tr> <tr><td align="center" style="border: 1px solid #E1E1E1"> <!--#include file="IncAsp/venshop_insid.asp"--> </td></tr> <%end if rs.close set rs=nothing%></table></td></tr></table></div>