按文章ID排序獲取當(dāng)前信息的上一篇信息與下一篇信息
獲得上一篇信息
<%
sql="select top 1 [id],[標(biāo)題] from [數(shù)據(jù)表名] where [id]<" & 當(dāng)前文章id & " order by id desc"
set rs=conn.execute(sql) 'conn為打開數(shù)據(jù)庫變量
if rs.eof then
response.write("上一篇文章：沒有了<br />")
else
response.write("上一篇文章：<a href='?id=" & rs(0) & "'>" & rs(1) & "</a><br />")
end if
rs.close
set rs=nothing
%>
獲得下一篇信息
<%
sql="select top 1 [id],[標(biāo)題] from [數(shù)據(jù)表名] where [id]>" & 當(dāng)前文章id & " order by id asc"
set rs=conn.execute(sql) 'conn為打開數(shù)據(jù)庫變量
if rs.eof then
response.write("上一篇文章：沒有了<br />")
else
response.write("上一篇文章：<a href='?id=" & rs(0) & "'>" & rs(1) & "</a><br />")
end if
rs.close
set rs=nothing
%>
蘇公網(wǎng)安備 32070502010230號