img_left_menu.asp

后台管理系统

<!--#include file="conn.asp"-->
 <ul>
   <li class="title">Related</li>
   <%
 '选出最新产品
set rs= Server.CreateObject("ADODB.Recordset")
rs_sqltxt="select top 10 product_name,id,big_sortid from product_info where big_sortid="&request("big_img_id")
rs.open rs_sqltxt,conn,1,1
'判断有无最新产品
		if rs.eof or rs.bof then
		response.write("<li class='group'>NO PRODUCTS</li>")
		else
while not rs.eof or rs.bof 
%>
        <li class="group"><a href="products_detail.asp?img_id=<%=rs("id")%>&big_img_id=<%=rs("big_sortid")%>"><%=server.HTMLENCODE(rs("product_name"))%></a></li>		
        <%
		rs.movenext
		wend
				end if

		rs.close
		set rs=nothing
		%>
      </ul>
      <ul>
        <li class="title">Recommand</li>
		<%
		'选出推荐产品
set rs= Server.CreateObject("ADODB.Recordset")
rs_sqltxt="select product_name ,id ,big_sortid from product_info  where tuijian=1"
rs.open rs_sqltxt,conn,1,1
'判断有无推荐产品
		if rs.eof or rs.bof then
		response.write("<li class='group'>NO RECOMANNDS</li>")
		else
while not rs.eof or rs.bof 
%>
       <li class="group"><a href="products_detail.asp?img_id=<%=rs("id")%>&big_img_id=<%=rs("big_sortid")%>"><%=rs("product_name")%></a></li>
	    <%
		rs.movenext
		wend
		end if
		rs.close
		set rs=nothing
		%>	
      </ul>