<%
set rs=server.createobject("adodb.recordset")
sql="select * from honor"
rs.open sql,conn,1,1
%>
<TABLE width=600>
<%
IF not rs.eof() then
FOR ii=1 to rs.recordcount/3
%>
<TR>
<%
for jj=1 to 3
if (ii mod 2)<>0 then
%>
<TD><%=rs("图片")%></TD>
<%else%>
<TD><%=rs("说明")%></TD>
<%
end if
if rs.eof() then Exit for
rs.movenext
next
%>
</TR>
<%
if rs.eof() then Exit For
Next
End IF
%>
</TABLE>
<%rs.close %>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from honor"
rs.open sql,conn,1,1
%>
<TABLE width=600>
<%
IF not rs.eof() then
FOR ii=1 to rs.recordcount/3
%>
<TR>
<%
for jj=1 to 3
if (ii mod 2)<>0 then
%>
<TD><%=rs("图片")%></TD>
<%else%>
<TD><%=rs("说明")%></TD>
<%
end if
if rs.eof() then Exit for
dovar=dovar+1
next
%>
</TR>
<%
if rs.eof() then Exit For
Next
End IF
%>
</TABLE>
<%
end if
rs.movenext
if rs.eof then
exit for
end if
i=i+1
next
rs.close
%>
</table>
<tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from honor"
rs.open sql,conn,1,1
i=1
for a=1 to 3
%>
<td align="center">
<table align="center"><tr><td align="center"><img src=<%=rs("img")%> width="100"></td></tr>
<tr><td align="center"><%=rs("title")%></td></tr>
</table>
</td>
<%
j=i mod 3
if j=0 then
%>
</tr>
<%
end if
rs.movenext
if rs.eof then
exit for
end if
i=i+1
next
rs.close
%>
</table>
</td>
</tr>
</table></td>
</tr>