tuijian.asp

来自「后台管理系统」· ASP 代码 · 共 43 行

<style type="text/css">
<!--
.STYLE1 {
	color: #FFFFFF;
	
}
.STYLE1 {
	letter-spacing: 1px;
	font-family: Arial, Helvetica, sans-serif;
	font-weight: bold;
}
-->
</style>
<table width="206" height="100%"  border="0" cellpadding="0" cellspacing="0" bgcolor="#f3f8fc">
  <tr align="center">
    <td height="26" colspan="2" align="left" bgcolor="#043d84"><span class="STYLE1">&nbsp;&nbsp;RECOMMAND</span></td>
  </tr>
  <tr bgcolor="#f3f8fc">
    <td colspan="2" align="center" valign="top">
	<% set rs_tuijian=server.createobject("adodb.recordset")
sql="select top 5 * from product_info where tuijian=1 and pass=1 order by id desc"
rs_tuijian.open sql,conn,1,1
if rs_tuijian.recordcount=0 then
response.Write("暂无推荐产品！")
end if
 %>
	<table width="206" cellpadding="0" cellspacing="0" bgcolor="#D3E9EA"  style="border:#A6C1DE 1px solid;border-TOP:none;">
	<% do while not rs_tuijian.eof %>
        <tr bgcolor="#F3F8FC">
          <td width="31" height="25" align="center" valign="middle" ><img src="img/leftarror.jpg" width="9" height="9"></td>
          <td width="149" align="left" ><a href="show_imgnews.asp?id=<%= rs_tuijian("id") %>" target="_blank"><%= rs_tuijian("product_name") %></a></td>
        </tr><tr><td height=1 bgcolor="#A6C1DE" colspan="2"></td>
					</tr>
		<% rs_tuijian.movenext
		   loop
		   'rs_tuijian.close
		   'set rs_tuijian=nothing
 %>
      </table>
    </td>
  </tr>
</table>