下一个记录 select * from table where id>$id order by id asc limit 1;



上一个记录 select * from table where id<$id order by id desc limit 1;回复




select  * from  html_content    where  id>5  order by  id  asc  limit  1;
select  * from  html_content    where  id<5  order by  id  desc  limit  1;