<table width="540" border="0">
                              
                              
                                  <%  


    set rsty=server.CreateObject("adodb.recordset")
        sqlty="select * from teacherInfo "
        'response.Write sqlty
        'response.end
        rsty.open sqlty,conn,3,1
        
        if not rsty.eof then
           for ii=0 to rsty.recordcount-1
       
           %>
    
  <tr >
    <td width="270"><a href="teacherInfo.asp?classid=<%=rsty("ID")%>"><img src="<%=rsty("imgurl")%>"/ width="270" height="203" border="0"></a>
   
    </td>
   
 
  </tr>
  <tr>
  <td>
  <%=rsty("caption")%>
  </td>
  </tr>
         
         
         
                <%
                        
                 rsty.movenext
              if rsty.eof then exit for
           next        
        end if
    
    rsty.close
    set rsty=Nothing
    

    %>
              
</table>

这样只读出 1列显示 怎么读出显示2列的

<tr>
 <td width="270"><a href="teacherInfo.asp?classid=<%=rsty("ID")%>"><img src="<%=rsty("imgurl")%>"/ width="270" height="203" border="0"></a>
 </td>
 <td>
  <%=rsty("caption")%>
 </td>
</tr>

在“for ii=0 to rsty.recordcount-1”之前加个rsty.MoveNext