上一篇文章和下一篇文章

本文来自小屋sjolzy.cn【原创】

ASP(ACCESS)制作方法:

上一条
select top 1 * from (select * from kc_words where [id]<2137) temp1 order by [id] desc

下一条
select top 1 * from (select * from kc_words where [id]>2137) temp1 order by [id] asc

PHP(MYSQL)制作方法:

上一条
select * from (select * from kc_words where [id]<2137) temp1 order by [id] desclimit 1

下一条
select * from (select * from kc_words where [id]>2137) temp1 order by [id] asclimit 1

注:红色为关键之处,蓝色为ACCESS与MYSQL之间SQL语句的区别之处。

本文永久地址:https://sjolzy.cn/Previous-article-and-the-next-article.html

--EOF--

标签: php

随机文章

添加新评论