100·ÖÇó¸öPHP ÉÏһƪ ÏÂÒ»±é - PHP / »ù´¡±à³Ì

select * from news where id<$id order by id limit 0,1
select * from news where id>$id order by id desc limit 0,1

 ÕâÖÖ·½·¨ÎÒÒѾ­ÊÔ¹ýÁË£¬È±µã¾ÍÊÇûÓа취ÅжϵÚһƪºÍ×îºóһƪ

 ×îºÃÓÐÏêϸµÄ´úÂë~

---

¿ÉÒԵģ¬ÄãÏÈcountÒ»ÏÂÊý¾Ý£¬µÃµ½Êý¾ÝµÄ×ÜÊý£¬¾ÍÄܼÆËã³öµÚһƪºÍ×îºóһƪ

---

ÒýÓÃ

select * from news where id<$id order by id limit 0,1
select * from news where id>$id order by id desc limit 0,1

ÕâÖÖ·½·¨ÎÒÒѾ­ÊÔ¹ýÁË£¬È±µã¾ÍÊÇûÓа취ÅжϵÚһƪºÍ×îºóһƪ

×îºÃÓÐÏêϸµÄ´úÂë~

×î´óµÄIDºÍ×îСµÄIDÎÒÒѾ­µÃ³öÀ´ÁË£¬²»ÖªµÀÔõôÅжÏŶ

---

select count(*) from news where id<$id order by id limit 0,1
ÕâÑù¾ÍÄÜÏȵõ½ÐÐÊý£¬È»ºóÄãÔÙ¿´limitµÄÊýÖµ£¬Ò»±È½Ï¾ÍokÀ²

---

µÃµ½×î´óidºÍ×îСid,È»ºóÓÃwhere id = $id ÕâÑùÄܲ»Äܸ㶨

---

Õâ¸öÊÇÎҵĴúÂë

  <?
  $sql = "select * from arts where id='$_GET[newsid]'";
  $res = mysql_query($sql,$conn);
  $row = mysql_fetch_array($res);
  ?>
  <div class="list_wen"><?=$row[contents]?></div>
  <div class="list_num a333">
  <?
  $sql_min = "select id from arts where arts_type_id=$newsmenu order by id limit 0,1";
  $res_min = mysql_query($sql_min,$conn);
  $row_min = mysql_fetch_array($res_min);