id排序输出就可以了..
举个例子:查看某本书的某一篇文章时..点上一篇文章或下一篇文章能够看到该书的对应章节..
如:turnid=reuqest.querystring("id")
bookname=request.querystring("bookname")
上一篇文章.
"select * from table where id<"&turnid&" and bookname="&bookname&" order by id desc"
<a href=a.asp?id=<%=rsobj("id")%>>上一篇文章</a>
下一篇文章
"select * from table where id>"&turnid&" and bookname="&bookname&" order by id"
<a href=a.asp?id=<%=rsobj("id")%>>下一篇文章</a>