建站常识

asp 从第几条开始读取数据 asp跳过前几条读取数据。

set rs=server.CreateObject( "adodb.recordset" )
sql= "select top 15 * from news order by id desc "
rs.open sql,conn,1,1
if rs.eof then 
response.write  "本类暂无新闻" 
else
i=0
do while not rs.eof
i=i+1
if i >=6 then  '从第几条开始读取，就写几
%>
<li> <a href= "/xxnews/<%=rs(" SMT_id ")%>.html"  target= "_blank"  title= "<%=rs(" SMT_title ")%>" ><%=rs( "SMT_title" )%></A></li>  
<%
end if
rs.movenext
loop
end if
rs.close
%>