注册 登录
编程论坛 ASP技术论坛

怎么横排数据库里读取的图片??(看看代码)

kuizhe425 发布于 2007-08-11 11:01, 517 次点击

<%
dim qzxx
qzxx=1
sql="select * from zxtg where ClassID='01' order by Articleid desc"
OpenRS rs,sql,1,1
if not rs.eof then
do while not rs.eof
%>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" valign="top">
<div align="center">
<img src="../qxe6/file/<%=rs("DefaultPicUrl")%>" width="69" height="90" border="0" />
</div>
</td>

</tr>
<tr>
<td><div align="right">姓名:</div></td>
<td><div align="left"><%=rs("UserName")%></div></td>
</tr>

<tr>
<td><div align="right">学历div></td>
<td><div align="left"><%=rs("zzxl")%></div></td>

</tr>
<tr>
<td><div align="right">专业:</div></td>
<td><div align="left"><%=rs("sxzy")%></div></td>
</tr>

<%
qzxx=qzxx+1
if qzxx=4 then
exit do
end if
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
</table>

从数据库里读取图片以及相关信息,在首页只显示3个。显示方式是横排。但是按着上面的代码的话显示方式是竖着的。
不知道该怎么做才能横排。请大家指教!谢谢!

2 回复
#2
madpbpl2007-08-11 11:21

<table><tr>
<%
dim qzxx
qzxx=1
sql="select * from zxtg where ClassID='01' order by Articleid desc"
OpenRS rs,sql,1,1
if not rs.eof then
do while not rs.eof
%>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" valign="top">
<div align="center">
<img src="../qxe6/file/<%=rs("DefaultPicUrl")%>" width="69" height="90" border="0" />
</div>
</td>

</tr>
<tr>
<td><div align="right">姓名:</div></td>
<td><div align="left"><%=rs("UserName")%></div></td>
</tr>

<tr>
<td><div align="right">学历div></td>
<td><div align="left"><%=rs("zzxl")%></div></td>

</tr>
<tr>
<td><div align="right">专业:</div></td>
<td><div align="left"><%=rs("sxzy")%></div></td>
</tr>
</table>
</td>

<%
qzxx=qzxx+1
if qzxx=4 then
exit do
end if
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
</tr></table>


#3
kuizhe4252007-08-11 13:03

OK了。。。厉害。。谢谢。。。!

1