ASP横向显示数据问题!!高手帮忙,所有分愿全献出!代码如下 我想横向显示三条记录
<divalign="center"><!--#includefile="conn.asp"--><%exec="select*fromadmin"setrs=serve...
<div align="center">
<!--#include file="conn.asp"-->
<%
exec="select * from admin "
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
rs.PageSize=3
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
rs.AbsolutePage=page
%>
<%for i=1 to rs.PageSize%>
<%if rs.EOF then
exit for
end if%>
<table width="461" border="5" bordercolor="#33CC66">
<tr align="center">
<td colspan="4">小佳会员系统</td>
</tr>
<tr>
<td colspan="2" align="center"><input type="checkbox" name="checkbox" value="checkbox"></td>
<td width="56">用户名:</td>
<td width="206"><%=rs("username")%></td>
</tr>
<tr>
<td width="42" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">修改</a></span></td>
<td width="46" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">删除</a></span></td>
<td>用户图片:</td>
<td><img src="tupian/<%=rs("im")%>" width="120" height="90" alt="" style="background-color: #009933"></td>
</tr>
</table>
<%rs.movenext
next
%>
</div> 展开
<!--#include file="conn.asp"-->
<%
exec="select * from admin "
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
rs.PageSize=3
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
rs.AbsolutePage=page
%>
<%for i=1 to rs.PageSize%>
<%if rs.EOF then
exit for
end if%>
<table width="461" border="5" bordercolor="#33CC66">
<tr align="center">
<td colspan="4">小佳会员系统</td>
</tr>
<tr>
<td colspan="2" align="center"><input type="checkbox" name="checkbox" value="checkbox"></td>
<td width="56">用户名:</td>
<td width="206"><%=rs("username")%></td>
</tr>
<tr>
<td width="42" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">修改</a></span></td>
<td width="46" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">删除</a></span></td>
<td>用户图片:</td>
<td><img src="tupian/<%=rs("im")%>" width="120" height="90" alt="" style="background-color: #009933"></td>
</tr>
</table>
<%rs.movenext
next
%>
</div> 展开
展开全部
<table width="461" border="5" bordercolor="#33CC66">
<tr align="center">
<td colspan="8">小佳会员系统</td>
</tr>
<tr>
<%for i=1 to rs.PageSize%>
<%if rs.EOF then
exit for
end if%>
<td><table cellpadding="0" cellspacing="0" border="0">
<tr>
<td colspan="2" align="center"><input type="checkbox" name="checkbox" value="checkbox"></td>
<td width="56">用户名:</td>
<td width="206"><%=rs("username")%></td>
</tr>
<tr>
<td width="42" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">修改</a></span></td>
<td width="46" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">删除</a></span></td>
<td>用户图片:</td>
<td><img src="tupian/<%=rs("im")%>" width="120" height="90" alt="" style="background-color: #009933"></td>
</tr>
</table></td>
<%rs.movenext
next
%>
</tr>
</table>
改下table布局就可以了
也可以不改布局,上面名字循环完了再MOVEfirst
<tr align="center">
<td colspan="8">小佳会员系统</td>
</tr>
<tr>
<%for i=1 to rs.PageSize%>
<%if rs.EOF then
exit for
end if%>
<td><table cellpadding="0" cellspacing="0" border="0">
<tr>
<td colspan="2" align="center"><input type="checkbox" name="checkbox" value="checkbox"></td>
<td width="56">用户名:</td>
<td width="206"><%=rs("username")%></td>
</tr>
<tr>
<td width="42" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">修改</a></span></td>
<td width="46" align="center" bgcolor="#66FF99"><span class="style1"><a href="#">删除</a></span></td>
<td>用户图片:</td>
<td><img src="tupian/<%=rs("im")%>" width="120" height="90" alt="" style="background-color: #009933"></td>
</tr>
</table></td>
<%rs.movenext
next
%>
</tr>
</table>
改下table布局就可以了
也可以不改布局,上面名字循环完了再MOVEfirst
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询