沪ICP备05037183号
valign="top" bgcolor="#FFFFFF">
用户名:
密 码:
验证码:
<% set rs=server.createobject("adodb.recordset") sql="select * from product_category where grade=0 order by paixu asc" rs.open sql,conn,1,1 do while not rs.eof %> <% rs.movenext loop rs.close %>
【<%=rs("category")%>】
<% set rs1=server.createobject("adodb.recordset") sql1="select * from product_category where sjid="&rs("id")&" order by paixu asc" rs1.open sql1,conn,1,1 n=rs1.recordcount for i=1 to n if rs1.eof then exit for end if %> <% if i mod 2=0 then %> <% end if rs1.movenext next rs1.close %>
&scategory=<%=rs1("category")%>"> <%=rs1("category")%>
 首页最新推荐
<% set rs=server.createobject("adodb.recordset") sql="select * from product where tj_index=1 order by id desc" rs.open sql,conn,1,1 for i=1 to 4 if rs.eof then exit for end if %> <% if i mod 4=0 then response.write "" end if rs.movenext next rs.close %>
" width="100" height="100">
" target="_blank" title="<%=rs("name")%>"><%=strvalue(rs("name"),15)%>
  市场价 会员价  
原装 <%=rs("price")%> <%=rs("price1")%>
代用 <%=rs("price2")%> <%=rs("price3")%>
 新品上市
<% set rs=server.createobject("adodb.recordset") sql="select * from product where tj_new=1 order by id desc" rs.open sql,conn,1,1 for i=1 to 4 if rs.eof then exit for end if %> <% if i mod 4=0 then response.write "" end if rs.movenext next rs.close %>
" width="100" height="100">
" target="_blank" title="<%=rs("name")%>"><%=strvalue(rs("name"),15)%>
  市场价 会员价  
原装 <%=rs("price")%> <%=rs("price1")%>
代用 <%=rs("price2")%> <%=rs("price3")%>
 销售排行
<% set rs=server.createobject("adodb.recordset") sql="select * from product where xs>0 order by xs asc" rs.open sql,conn,1,1 for i=1 to 10 if rs.eof then exit for end if %> <% rs.movenext next rs.close %>
" target="_blank">·<%=rs("name")%>
 关注排行
<% set rs=server.createobject("adodb.recordset") sql="select * from product where gz>0 order by gz asc" rs.open sql,conn,1,1 for i=1 to 10 if rs.eof then exit for end if %> <% rs.movenext next rs.close %>
" target="_blank">·<%=rs("name")%>
 特价排行
<% set rs=server.createobject("adodb.recordset") sql="select * from product where tj>0 order by tj asc" rs.open sql,conn,1,1 for i=1 to 10 if rs.eof then exit for end if %> <% rs.movenext next rs.close %>
" target="_blank">·<%=rs("name")%>