【开源中国 APP 全新上线】“动弹” 回归、集成大模型对话、畅读技术报告”
<? mysql_connect('localhost','root','123456') or die(mysql_error()); mysql_select_db('jsd'); mysql_query("set names 'utf8'"); $cid=$_REQUEST['id'];//是你当前文章的编号 $sql ="select * from pyl_main where id>$cid and Ppid=58 order by id desc limit 0,1"; //上一篇文章 $sql1 ="select * from pyl_main where id<$cid and Ppid=58 order by id asc limit 0,1";//下一篇文章 $result = mysql_query( $sql ); if( mysql_num_rows( $result ) ) { $rs = mysql_fetch_array( $result ); echo "上一篇<A href='k.php?id=".$rs['id']."&pid=".$rs['Ppid']."'>".$rs['Pname']."</a>"; } else { echo "没有了"; } $result1 = mysql_query( $sql1 ); if( mysql_num_rows( $result1 ) ) { $rs1 = mysql_fetch_array( $result1 ); echo "下一篇<A href='k.php?id=".$rs['id']."&pid=".$rs['Ppid']."'>".$rs['Pname']."</a>"; } else { echo "没有了"; } ?>郁闷中为什么不行呢?
这样试试
$sql ="select * from pyl_main where id<$cid and Ppid=58 order by id desc limit 1"; //上一篇文章
$sql1 ="select * from pyl_main where id>$cid and Ppid=58 order by id asc limit 1";//下一篇文章
引用来自“彭哥”的答案
//前一个id
SELECT MAX(id) FROM pyl_main WHERE id < $cid AND Ppid=58 ORDER BY id DESC
//后一个id
SELECT MIN(id) FROM pyl_main WHERE id > $cid AND Ppid=58 ORDER BY id ASC