怎么查工商银行的余额:ASP分列问题,请教大家!!

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/04 04:27:30
要使下面这段代码显示的内容变成4行2列,怎么改动才好,谢谢高手指教!!
<table width="76%" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<%
'---------分页操作
'创建对象
Set mypage=new xdownpage
'得到数据库连接
mypage.getconn=conn
'sql语句
mypage.getsql="select * from class order by ID desc"
'设置每一页的记录条数据为5条
mypage.pagesize=4
'返回Recordset
set rs=mypage.getrs()
for i=1 to mypage.pagesize
if not rs.eof then
'do while not rs.eof
xid=rs("id")
xbb=""
set rsc=server.createobject("adodb.recordset")
sqlc="select * from flclass where classid="&xid&" order by ID desc "
rsc.open sqlc,conn,1,1
if not rsc.eof then
xbb="dfdsf"
end if
rsc.close
%>
<tr>
<td width="5%"><div align="center"><img src="/images/d.gif" width="5" height="5" /></div></td>
<td width="75%" height="30"><span class="style14">
<%if xbb="" then%>
<div align="left"><a href="list1.asp?id=<%=xid%>"><font color="#000000"><%=rs("name")%></font></a></div>
<%else%>
<div align="left"><a href="index1.asp?id=<%=xid%>"><font color="#000000"><%=rs("name")%></font></a></div>
<%end if%>
<div align="left"></div>
</span></td>
</tr>
<%set rs1=server.createobject("adodb.recordset")
sql1="select * from desktop where (classid="&xid&" or flclassid="&xid&") and minipic is not null order by ID desc "
'response.write(sql1)
rs1.open sql1,conn,1,1
if rs1.eof and rs.bof then%>
<tr>
<td colspan="2"><div align="center"><span class="STYLE13">sorry,is not contents.</span></div></td>
</tr>
<%else
x=1
while not rs1.eof and x<=1
%>
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" rowspan="3"><div align="center"><a href="showconten.asp?id=<%=rs1("id")%>"><img src="/admin/<%=rs1("minipic")%>" border='0' width="100" height="100" class='bk' /></a></div></td>
<td width="70%"><strong><a href="showconten.asp?id=<%=rs1("id")%>"><font color="#000000"><%=rs1("name")%></font></a></strong></td>
</tr>
代码没有打全,完整代码在这里http://post.baidu.com/f?kz=100588450

这个表示方式我知道,但是怎么搞代码也不对,真是郁闷,有没有高手教教我,

可参考下面代码实现:
<table width="100%" border="0">
<%for i=1 to 4%>
<tr>
<%for r=1 to 2%>
<td>每列二个</td>
<%next%>
</tr>
<%next%>
</table>

如果要调试到下一条记录,就要用到两个

<tr>
<td><%=rs1("字段名称")%> </td>
<% rs1.movenext %>
<td><%=rs1("字段名称")%> </td>
</tr>
<% rs1.movenext %>