📄 newleft.asp

📁 以前企业建网站
💻 ASP
字号:
<body topmargin="0">

<table border="0" width="146" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<tr>
<td >
<p>
<p>
		<table width="99%" cellspacing="0" cellpadding="0" border="0" height="83" id="table1">
			<tr>
				<td class="box1" align="center" height="25" background="images/an-bg04.gif" >
				<font color="#FFFFFF">※ 动态类别 ※</font></td>
			</tr>
              <%sql="select * from newsclass"
              rs.open sql,conn,3,3
              if rs.eof then
                  response.write "暂且没有分类"
              else
                  do while not rs.eof
                  %>
			<tr>
				<td bgcolor="#FFFFFF" valign="middle" height="25">
				&nbsp;
				<img border="0" src="images/d_1.gif" width="13" height="13"><font color="#000000"><a href="sortnew.asp?newsclass_id=<%=rs("newsclass_id")%>">&nbsp;<%=rs("newsclass_name")%>(   
                  <%  
                     set rs1=server.createobject("adodb.recordset")  
                     newsclass_id=rs("newsclass_id")  
                     sql1="select * from news where newsclass_id='"&newsclass_id&"'"  
                     rs1.open sql1,conn,3,3  
                     response.write rs1.recordcount  
                     rs1.close  
                     %>  
 条)</a></font></td>
			</tr>
              <%rs.movenext
                  loop
              end if
              rs.close
              %>
			<tr>
				<td height="29" >
				</td>
			</tr>
		</table>
		<table width="147" border="0" cellspacing="1" cellpadding="5" height="108" >
			<tr>
				<td background="images/an-bg04.gif" height="25" width="135">
				<p align="center"><font color="#FFFFFF">※ 热销商品 ※</font></td>
			</tr>
			<tr>
				<td>
				<%                
sql="select top 10  * from hw order by hw_buys DESC"                
rs.open sql,conn,3,3                
if rs.eof then                
%>
本站目前没有成交任何商品<br><%end if %>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<%
i=0
do while not rs.eof and i<=10 %>
	<tr>
		<td height="20"><img border="0" src="images/news.gif" width="10" height="9">&nbsp;<a href="watch.asp?hw_id=<%=rs("hw_id")%>"><%=rs("hw_name")%></a></td>
	</tr>

<%
i=i+1
rs.movenext
loop
rs.close%><br></table>    </td>
			</tr>
</table>　</td>
</tr>
</table>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -