主题:请问一个排序的问题
我在做图片显示的时候,本来是循环显示10张图片,但是只显示了第一张,请问是什么原因,是哪个地方循环语句写错了?麻烦各位指点一下,我也是这里常客了。代码如下:
<table width="699" height="57" border="0" cellpadding="0" cellspacing="0">
<tr>
<%set rss=server.CreateObject("adodb.recordset")
sqls="select top 10 * from market"
rss.open sqls,conn
do while not rss.eof
%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
</tr> <%rss.movenext
loop
rss.close%>
</table>
<table width="699" height="57" border="0" cellpadding="0" cellspacing="0">
<tr>
<%set rss=server.CreateObject("adodb.recordset")
sqls="select top 10 * from market"
rss.open sqls,conn
do while not rss.eof
%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
<%rss.movenext
if not rss.eof or rss.bof then
response.Write "<td width='100'> </td>"
exit do
end if%>
<td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
<tr>
<td height="19"><div align="center"><%=rss("p_name")%></div></td>
</tr>
<tr>
<td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
</tr>
</table></td>
</tr> <%rss.movenext
loop
rss.close%>
</table>