那位高手来看一下这个ASP,我想只想显示20个.怎么改啊
我想只显示20个...如果过了20个就有下一页上一页..怎么改啊..
<table width="379" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<%
Set rs = Server.CreateObject ("ADODB.Recordset")
sql="select * from 6623 order by id desc"
rs.Open sql, conn, 1,1
if rs.eof and rs.bof then
response.write "该类还没有任何影片!"
response.end
else
%>
<tr>
<%
tempnum2=1
do while not rs.eof
%>
<td width="379" height="172"><table border="1">
<tr>
<td width="120" height="27" rowspan="3" ><a href="<%=rs("singer")%>"><img src=<%=rs
("pic")%> width=120 height=150 border=0></a></td>
<td width="320" height="33" ><%=rs("mc")%></td>
<tr>
<td height="33" ><%=rs("singer")%></td>
<tr>
<td ><iframe scrolling="no" frameborder="0" height="70" width="200" src="pc.asp?mc=<%
=rs("mc")%>"> </iframe> </td>
</tr>
</table></td>
<%
if (tempnum2 mod 2)=0 then response.write "</tr>" '五列显示mod 5
tempnum2=tempnum2+1
rs.MoveNext()
loop
%>
</tr>
<%
end if
%>
</table>
在线等啊..我的QQ880049.你可以加我...如果可以的话.我可以追加30分...谢谢了啊
参考答案:sql="select top 20 * from 6623 order by id desc"