上一条，下一条

[fuzijing]

有的网站新闻详细页面，下面有
上一条新闻，下一条新闻

一般是怎么做的？ 就自己处理新闻ID??

[Robin]

下一条select top 1 * from table1 where id>@id order by id
上一条select top 1 * from table1 where id <@id order by id desc

[xupeihuagudulei]

up

[oec2003]

就是根据当前文章的id查出 前后id

[a12321321321312321]

[Quote=引用 1 楼 huangshihu1 的回复:]
下一条select top 1 * from table1 where id>@id order by id
上一条select top 1 * from table1 where id <@id order by id desc
[/Quote]

同意