do while not rs_b.eof...rs_b.movenext...loop

 

<style type="text/css">
<!--
body {
 margin-left: 0px;
 margin-top: 0px;
 margin-right: 0px;
 margin-bottom: 0px;
}
-->
</style>

<style type="text/css">
<!--
a {
 font-size: 12px;
 color: #333333;
}
a:link {
 text-decoration: none;
}
a:visited {
 text-decoration: none;
 color: #333333;
}
a:hover {
 text-decoration: none;
 color: #FF0000;
}
a:active {
 text-decoration: none;
}

-->
</style>
<link href="web.css" rel="stylesheet" type="text/css" />
<br />
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="29" background="images/lf-cp.jpg" class="about">产品分类</td>
  </tr>
  <tr>
    <td height="71" valign="top" background="images/lfbg.jpg"><br /><table width="98%" border="0" cellpadding="0" cellspacing="0"  >
      <tbody>
        <%
   SortSql="Select * From lb order by id asc"
 Set SortRs= Server.CreateObject("ADODB.Recordset")
 SortRs.Open SortSql,Conn,1,1
 if SortRs.EOF and SortRs.BOF then
  Response.Write "暂无相关数据"
 else
%>
        <% do while not SortRs.EOF %>
        <tr>
          <td width="24%" align="right" valign="middle" ><img src="images/dian.jpg" /></td>
          <td width="76%" height="30" align="left" valign="middle" ><a href="product.asp?lb=<%=SortRs("id") %>"><span >
                   　
                   <% =SortRs("title") %>
          </span> </a> </td>
        </tr>
        <tr>
          <td height="4" colspan="2" align="center" valign="middle" ><img src="images/xian.jpg" /></td>
        </tr>
        <%
  SortRs.MoveNext
 Loop
%>
        <%
 End if
 SortRs.Close
 Set SortRs=Nothing

%>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td><img src="images/lf-lx.jpg" width="211" height="38"></td>
  </tr>
  <tr>
    <td height="62" valign="top" background="images/lfbg.jpg" class="lfzi"　class="lfzi"><br />
      联系人:田昆育(坤楠)经理 <br />
      手 机:13066186099<br />
电 话:0769-85335501－3 <br />
传 真:0769-85358406 <br />
网 址:<a href="http://www.jmsdg.com%22%3ewww.jmsdg.com%3cbr/ />
</a></td>
  </tr>
  <tr>
    <td height="62" align="center" background="images/lfbg.jpg"><br /><img src="images/men.jpg" width="200" height="179"></td>
  </tr>
  <tr>
    <td><img src="images/di.jpg" width="211" height="4"></td>
  </tr>
</table>

 

转载于:https://www.cnblogs.com/net2/archive/2010/10/09/1846448.html