上一条、下一条SQL 上一篇下一篇带分类

/* NEXT */
SELECT
	A.NEWS_ID,A.TITLE
FROM
	CONTENT_NEWS A
INNER JOIN CONTENT_NEWS B ON B.`COLUMN` = A.`COLUMN` AND B.NEWS_ID =11 
WHERE A.NEWS_ID > 11 
ORDER BY NEWS_ID ASC
limit 0,1;

/* PREV */
SELECT
	A.NEWS_ID,A.TITLE
FROM
	CONTENT_NEWS A
INNER JOIN CONTENT_NEWS B ON B.`COLUMN` = A.`COLUMN` AND B.NEWS_ID =11 
WHERE A.NEWS_ID < 11 
ORDER BY NEWS_ID DESC
limit 0,1;