上一主题下一主题:以PID为标记? select * from tt where pid>当前PID ORDER BY PID ASC(DESC) LIMIT 1
把当前 pid 做为参数传到新的页面 比如 127 上一主题 select * from posts where pid<127 order by pid desc limit 1; 下一主题 select * from posts where pid>127 order by pid limit 1;
pid是连续的就好了。 自增列,且不允许删除文章, select * from posts where pid = current_id-1 select * from posts where pid = current_id+1
select * from tt where pid>当前PID ORDER BY PID ASC(DESC) LIMIT 1
上一主题
select * from posts where pid<127 order by pid desc limit 1;
下一主题
select * from posts where pid>127 order by pid limit 1;
自增列,且不允许删除文章,
select * from posts where pid = current_id-1
select * from posts where pid = current_id+1