📄 newleft.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">
<img border="0" src="images/d_1.gif" width="13" height="13"><font color="#000000"><a href="sortnew.asp?newsclass_id=<%=rs("newsclass_id")%>"> <%=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"> <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 + -