pingpaiinfo.asp

电子商务购物系统

                      <%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 10 * from pingpai where tuijian=1 order by pingpaiorder",conn,1,1
if rs.eof and rs.bof then
response.write "<center>&nbsp;</center>"
else%>
<table width="100%" class="table-shangxia" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td height="23" bgcolor="f1f1f1">　<font color="#990000">品牌推荐</font></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td> 
      <table width="91%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="2"></td>
        </tr>
        <tr> 
          <td height="19"> 
            <div align="center"> </div>
          </td>
        </tr>
        <tr> 
          <td class="table-xia"> 
            <%
		  while not rs.eof
		  response.write "·<a href=research.asp?action=2&searchkey="&trim(rs("pingpainame"))&" target=_blank>"&trim(rs("pingpainame"))&"</a><br>"
		  rs.movenext
		  wend
		  %>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td height="19">&nbsp;</td>
  </tr>
</table>
                      <%end if
rs.close
set rs=nothing%>