UC知道在数据库提取6张图片 怎么分三行显示
来源：百度知道 编辑：UC知道 时间：2024/05/05 12:01:31
<table border=0 cellspacing=0 cellpadding=0 width='122'>
<tr align=center>
<%
dim nid,nname,nemoney,pnum,w_num,vvt
sql="select top 6 id,name,spic,emoney,power,counter from photo where hidden=1 order by id desc"
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
nid=rs("id")
nname=rs("name")
nemoney=rs("emoney")
%>
<td width='<%response.write pnum%>%'>
<table border=0 cellspacing=0 cellpadding=2>
<tr><td align=center><%response.write pic_fk(rs("spic"),1,"photo_view.asp?id="&nid)%></td></tr>
<%if vvt>0 then%>
<%if vvt>1 then%>
<tr><td align=center><%response.write format_emoney_power(nemoney,rs("power"),0)%></td></tr>
<%
end if
<tr align=center>
<%
dim nid,nname,nemoney,pnum,w_num,vvt
sql="select top 6 id,name,spic,emoney,power,counter from photo where hidden=1 order by id desc"
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
nid=rs("id")
nname=rs("name")
nemoney=rs("emoney")
%>
<td width='<%response.write pnum%>%'>
<table border=0 cellspacing=0 cellpadding=2>
<tr><td align=center><%response.write pic_fk(rs("spic"),1,"photo_view.asp?id="&nid)%></td></tr>
<%if vvt>0 then%>
<%if vvt>1 then%>
<tr><td align=center><%response.write format_emoney_power(nemoney,rs("power"),0)%></td></tr>
<%
end if
程序代码如下:
<table width="100" border="1" cellspacing="0" cellpadding="0">
<%
temp=0
for i=1 to 100
i=i+1
temp=temp+1
temp1=temp mod 2
if temp1=1 then
response.write("<tr>")
end if
%>
<td bgcolor="#D4D0C8"><%=temp1%></td>
<%
if temp1=0 then
response.write("</tr>")
end if
next
%>
</table>
代码刚才写的.有点乱...
不清楚的,可以加QQ问我:5283748
msn:binghan2004@hotmail.com