shops.asp

采用asp+fso技术 傻瓜式的程序安装和调试 用户无需考虑系统的安装维护 美观、友好的展示铺面 设计中应用了多种网络安全技术 顾客可以方便的查询并订购商品 用户可以方便的定义各种商品信息

<%set rs=server.CreateObject("adodb.recordset")
rs.open "select Top 10 * from shjia where flag=2 order by adddate desc",conn,1,1
%>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" class="table-zuoyou" bordercolor="#CCCCCC">
<tr> 
<td width="180" rowspan="2" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="180" height="60" background="images/guide06.gif"></td>
</tr>
<%do while not rs.eof%>
<tr> 
<td height="24" class="table-you" background="images/bg_guide02.gif" STYLE='PADDING-LEFT: 18px'>
<%response.write "<a href=user/index.asp?id="&rs("shjiaid")&" >"
				if len(trim(rs("name")))>12 then
				response.write left(trim(rs("name")),10)&".."
				else
				response.write trim(rs("name"))
				end if
				response.write "</a>"
				%>
</td>
</tr>
<%rs.movenext
	loop
	rs.close
	set rs=nothing%>
</table></td>
<td width="580" height="30" bordercolor="#FFFFFF" background="images/bg61030.gif" bgcolor="#FFFFFF">　<img src="images/search01.gif" width="17" height="13" align="bottom">　<a href="speciality.asp" target="_blank">最旺商铺 &amp; 明星商铺</a></td>
</tr>
<tr> 
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select Top 20 * from shjia where tj>2 order by adddate desc",conn,1,1
%>
<td valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<table width="100%" border="0" align="center"  cellSpacing="1" cellPadding="0" bgColor="#efefef">
<%
do while not rs.eof
%>
<tr> 
<td width="25%" height="25" bgcolor="#FFFFFF">&nbsp;<img src="images/ring01.gif" width="9" height="9">
<%response.write "<a href=user/index.asp?id="&rs("shjiaid")&" >"
				if len(trim(rs("name")))>10 then
				response.write left(trim(rs("name")),8)&".."
				else
				response.write trim(rs("name"))
				end if
				response.write "</a>"
				%>
<%rs.movenext%>
</td>
<td width="25%" height="25" bgcolor="#FFFFFF">&nbsp;<img src="images/ring01.gif" width="9" height="9">
<%if rs.eof then%>
<%else%>
<%response.write "<a href=user/index.asp?id="&rs("shjiaid")&" >"
				if len(trim(rs("name")))>10 then
				response.write left(trim(rs("name")),8)&".."
				else
				response.write trim(rs("name"))
				end if
				response.write "</a>"
				%>
<%rs.movenext%>
<%end if%>
</td>
<td width="25%" height="25" bgcolor="#FFFFFF">&nbsp;<img src="images/ring01.gif" width="9" height="9">
<%if rs.eof then%>
<%else%>
<%response.write "<a href=user/index.asp?id="&rs("shjiaid")&" >"
				if len(trim(rs("name")))>10 then
				response.write left(trim(rs("name")),8)&".."
				else
				response.write trim(rs("name"))
				end if
				response.write "</a>"
				%>
<%rs.movenext%>
<%end if%>
</td>
<td width="25%" height="25" bgcolor="#FFFFFF">&nbsp;<img src="images/ring01.gif" width="9" height="9">
<%if rs.eof then%>
<%else%>
<%response.write "<a href=user/index.asp?id="&rs("shjiaid")&" >"
				if len(trim(rs("name")))>10 then
				response.write left(trim(rs("name")),8)&".."
				else
				response.write trim(rs("name"))
				end if
				response.write "</a>"
				%>
				<%rs.movenext%>
				<%end if%>
</td>
</tr>
<%loop
rs.close
set rs=nothing%>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr> 
<td height="15" colspan="4"></td>
</tr>
<tr> 
<td height="25" colspan="4" align="center">::::<a href=user/admin_login.asp >推荐品牌商家快速入口</a>:::: <a href=speciality.asp >更多品牌商家</a>... <a href=reg_shang.asp >马上加入商家商盟</a></td>
</tr>
<tr> 
<td><a href=<%=xiao1url%> target="_blank"><img src=<%=xiao1%> border="0" width="142" height="60"></a></td>
<td><a href=<%=xiao2url%> target="_blank"><img src=<%=xiao2%> border="0" width="142" height="60"></a></td>
<td><a href=<%=xiao3url%> target="_blank"><img src=<%=xiao3%> border="0" width="142" height="60"></a></td>
<td><a href=<%=xiao4url%> target="_blank"><img src=<%=xiao4%> border="0" width="142" height="60"></a></td>
</tr>
<tr> 
<td><a href=<%=xiao5url%> target="_blank"><img src=<%=xiao5%> border="0" width="142" height="60"></a></td>
<td><a href=<%=xiao6url%> target="_blank"><img src=<%=xiao6%> border="0" width="142" height="60"></a></td>
<td><a href=<%=xiao7url%> target="_blank"><img src=<%=xiao7%> border="0" width="142" height="60"></a></td>
<td><a href=<%=xiao8url%> target="_blank"><img src=<%=xiao8%> border="0" width="142" height="60"></a></td>
</tr>
</table></td>
</tr>
</table>