请教如何显示数据库的内容？

[Miriamy]

取出数据库中有20条记录，有两列，左边列显示奇数行的个息，右边列显示偶数行的信息？
如何做？

[friendlyFour]

inti=1
Response.write "<table border=0>"
do while

if inti mod 2 = 1 then
response.write "<tr>"
end if
Response.write inti&"<td>"&rs("xxx")&"</td>"
if inti mod 2 = 0 then
response.write "</tr>"
end if
inti=inti+1
loop
Response.write "</table>"

[lnboy1003]

<tr>

<td><table>
<%
for i=1 to rs.recordcount

if rs("id") mod 2 = 1 then
%><tr><td>
<%=rs("id")%>
</td></tr>
<%
end if
rs.movenext
next
%>
</table></td>
<td><table>
<%
rs.movefirst
for i=1 to rs.recordcount

if rs("id") mod 2 = 0 then
%><tr><td>
<%=rs("id")%>
</td></tr>
<%
end if
rs.movenext
next
%>
</table></td>

</tr>