Question

asp横向循环显示数据库内产品图片和名称

RT我想把数据库中的产品图片和名称横向循环显示，每行显示7个
<table class="IPart1SortList" cellpadding="0" cellspacing="0" border="1" width="70"><tr><td align="center">
<% set rs=server.createobject("adodb.recordset")
sql="select top 20 * from Brand where classid in (select cstr(Classid) from Brandclass where upid=15) order by brandid desc "
rs.open sql,conn,1,1
for rsc=1 to 20
if not rs.eof then

%>
<% if trim(rs("logo"))<>"" then%>

</td></tr><tr><td align="center"> <a href="BrandInfo.asp?BrandID=<%=rs("brandid")%>" target="_blank" > <img src="<%=rs("logo")%>" alt="齐齐哈尔团购_<%=rs("name")%>" boder=1 width="141" height="102"/> <%=rs("name")%></a>
<%else%> </td></tr><tr><td align="center"><a href="BrandInfo.asp?BrandID=<%=BrandID%>" target="_blank" >

<img src="images/1.jpg" boder=0 width="141" height="102" border="1"/> <%=rs("name")%>
</a>
<%end if%><%
rs.movenext
if rsc=7 then
response.write("<br></br>")
end if
else
end if
next
rs.close
%>

</td>
</tr> </table>
如果我这样写 产品就是竖着循环的
请高手 回复代码

Answer 1

你在每个<td>中内嵌一个<table>就行了，<table>中放置每个产品的图片、名称即可，然后循环<td>就行了

Answer 2

<table>
<tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select top 20 * from Brand where classid in (select cstr(Classid) from Brandclass where upid=15) order by brandid desc "
rs.open sql,conn,1,1
Dim rsc,str1
rsc = 0
if not rs.eof then
Do While Not rs.eof
If rsc = 7 Then
response.write ("</tr><tr><td>" )
rsc = 1
Else
response.write ("<td>" )
rsc = rsc + 1
End If
if trim(rs("logo"))<>"" Then
%>
<a href="BrandInfo.asp?BrandID=<%=rs("brandid")%>" target="_blank" > <img src="<%=rs("logo")%>" alt="齐齐哈尔团购_<%=rs("name")%>" boder=1 width="141" height="102"/> <%=rs("name")%></a>
<%
else
%>
<a href="BrandInfo.asp?BrandID=<%=BrandID%>" target="_blank" ><img src="images/1.jpg" boder=0 width="141" height="102" border="1"/> <%=rs("name")%> </a>
<%
End If
response.write("</td>")
rs.movenext
Loop
End if
%>
</table>

Answer 3

去掉当中的</tr><tr>