![]() |
#2
robinbest2008-06-26 12:38
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr> <td> <% sql = "SELECT * FROM ZJnews ORDER BY postdate desc" Set rs = Server.CreateObject("ADODB.Recordset") rs.OPEN sql,Conn,1,1 i=1 Do While (Not rs.eof) %> <table width="280" height="96" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="99" rowspan="3" align="center" valign="middle"> <img name="pImg" src='<%="./images/"&rs("picture")%>' width="90" height="90" alt=""></td> <td width="148" height="20" align="center" valign="middle"><%=rs("ZJname")%></td> <td width="33"> </td> </tr> <tr> <td height="20" align="center" valign="middle"><%=rs("cbdate")%></td> <td> </td> </tr> <tr> <td align="left" valign="top"><%=rs("jieshao")%></td> <td> </td> </tr> </table> <% if i mod 2 = 0 then response.write"</tr><tr>" i=i+1 rs.movenext 'loop %> </td> </tr> </table> <% rs.close set rs=nothing %> [[it] 本帖最后由 robinbest 于 2008-6-26 12:41 编辑 [/it]] |
我想做到这个效果,就是横向重复2次后换行..显示4条记录!请问这个怎样做!简单点.弄点说明好吗?
<%
sql = "SELECT * FROM ZJnews ORDER BY postdate desc"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.OPEN sql,Conn,1,1
%>
<table width="280" height="96" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="99" rowspan="3" align="center" valign="middle"><img name="pImg" src='<%="./images/"&rs("picture")%>' width="90" height="90" alt=""></td>
<td width="148" height="20" align="center" valign="middle"><%=rs("ZJname")%></td>
<td width="33"> </td>
</tr>
<tr>
<td height="20" align="center" valign="middle"><%=rs("cbdate")%></td>
<td> </td>
</tr>
<tr>
<td align="left" valign="top"><%=rs("jieshao")%></td>
<td> </td>
</tr>
</table>
<%rs.movenext
'loop
rs.close
set rs=nothing
%>