www.gusucode.com > 运动用品商城网站系统源代码程序 > sortid5.asp

    
<%
sort_id=5
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>