Question

在asp中如何快速实现 文章的上下一篇的显示

效果如图中所示在ASP中的代码怎么写？望解答

Answer 1

<%
'id为当前id
set rs=Server.CreateObject("adodb.recordset")
rs.open "select top 1 * from News where BigClassName='News' and id>"&id&" order by ID asc",conn,1,1
if rs.recordcount>0 then
id2=rs("ID")
else
id2=""
end if
rs.close
set rs=nothing
set rs=Server.CreateObject("adodb.recordset")
rs.open "select top 1 * from News where BigClassName='News' and id<"&id&" order by ID desc",conn,1,1
if rs.recordcount>0 then
id3=rs("ID")
else
id3=""
end if
rs.close
set rs=nothing
%>
<tr>
<td align="center" valign="top" style="padding-top:10px; padding-bottom:20px;"><% if id3<>"" then%>[<a href="newsdetail.asp?id=<%=id3%>" class="hei"> Prev </a>] <% end if %> <% if id2<>"" then%>[<a href="newsdetail.asp?id=<%=id2%>" class="hei"> Next </a> ] <%end if%>[ <a href="news.asp" class="hei">Returm </a>]</td>
</tr>

Answer 2

获取当前ID，然后指针上移，下移就可以了。如果下移没有数据，加一个判断就可以了。