📄 left.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="201" id="table1">
<tr>
<td class="box1" align="center" height="26" background="images/an-bg04.gif" >
<font color="#FFFFFF">※ 商城公告※ </font></td>
</tr>
<tr>
<td class="box1" align="center" height="98" valign="top" >
<p style="line-height: 150%">
<script language=JavaScript>
<!--//
var version = "other"
browserName = navigator.appName;
browserVer = parseInt(navigator.appVersion);
if (browserName == "Netscape" && browserVer >= 3) version = "n3";
else if (browserName == "Netscape" && browserVer < 3) version = "n2";
else if (browserName == "Microsoft Internet Explorer" && browserVer >= 4) version = "e4";
else if (browserName == "Microsoft Internet Explorer" && browserVer < 4) version = "e3";
function stopError()
{
return true;
}
window.onerror = stopError;
function wireOpen()
{
if (version == "e4")
{
document.write("<marquee behavior=scroll direction=up width=146 height=120 scrollamount=1 scrolldelay=70 onmouseover='this.stop()' onmouseout='this.start()'>")
}
}
function wireClose()
{
if (version == "e4")
{
document.write("</marquee>")
}
}
//-->
</script>
<script language=JavaScript>
wireOpen();
</script><p style="line-height: 150%"><font style=font-size:9pt>
<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_gg")%>
<%rs.close%></font></p>
<script language=JavaScript>
wireClose();
</script> </td>
</tr>
<tr>
<td class="box1" align="center" height="25" background="images/an-bg04.gif" >
<font color="#FFFFFF">※ 商品类别 ※</font></td>
</tr>
<%sql="select * from sort"
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="sort.asp?sort_id=<%=rs("sort_id")%>"> <%=rs("sort_name")%>(
<%
set rs1=server.createobject("adodb.recordset")
sort_id=rs("sort_id")
sql1="select * from hw where sort_id='"&sort_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="27" >
<div align="center">本商城共有商品<font color="#FF0000">
<%
sql="select * from sort"
rs.open sql,conn,3,3
if rs.eof then
response.write "0"
else
do while not rs.eof
sort_id=rs("sort_id")
sql1="select * from hw where sort_id='"&sort_id&"'"
rs1.open sql1,conn,3,3
sort_total=rs1.recordcount
total=total+sort_total
rs1.close
rs.movenext
loop
response.write total
end if
rs.close
set rs1=nothing
%>
</font>件 </div></td>
</tr>
</table>
<table width="147" border="0" cellspacing="1" cellpadding="5" height="116" >
<tr>
<td background="images/an-bg04.gif" height="26" width="135">
<p align="center"><font color="#FFFFFF">※ 热销商品 ※</font></td>
</tr>
<tr>
<td>
<%
sql="select top 10 * from hw where hw_rx=true order by hw_id DESC"
rs.open sql,conn,3,3
if rs.eof then
%>
本站目前没有成交任何商品<%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 + -