shops.asp

闲置物品免费交易的平台

<%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="772" 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" height="42">
        <tr>
          <td width="180" height="30" background="images/main/th_bg.gif">
            <div align="center"><font color="#0000FF">新加盟商铺</font></div>
          </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=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/main/th_bg.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="100%" border="0" align="center" cellpadding="0" cellspacing="1">
   
        <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>