前往上一筆、下一筆資料

概念 創一個撈全部的資料集 在跟指定資料集比對id 如果比對到了 就從比對到的筆數 進行上一筆 下一筆

//RecNews 指定資料集
$colname_RecNews = "-1";
if (isset($_GET['news_id'])) {
  $colname_RecNews = $_GET['news_id'];
}
mysql_select_db($database_connectPrince, $connectPrince);
$query_RecNews = sprintf("SELECT * FROM news WHERE news_id = %s  AND news_active=1 ", GetSQLValueString($colname_RecNews, "int"));
$RecNews = mysql_query($query_RecNews, $connectPrince) or die(mysql_error());
$row_RecNews = mysql_fetch_assoc($RecNews);
$totalRows_RecNews = mysql_num_rows($RecNews);

//RecNewsAll 全部資料集 要把$row_RecNewsAll = mysql_fetch_assoc($RecNewsAll);;給註解掉才不會衝突
mysql_select_db($database_connectPrince, $connectPrince);
$query_RecNewsAll = "SELECT * FROM news WHERE news_active = 1 ORDER BY news_date DESC";
$RecNewsAll = mysql_query($query_RecNewsAll, $connectPrince) or die(mysql_error());
//$row_RecNewsAll = mysql_fetch_assoc($RecNewsAll);
$totalRows_RecNewsAll = mysql_num_rows($RecNewsAll);

//=======================================================
$id=$_GET['news_id'];
$ii = 0;
while($row = mysql_fetch_array($RecNewsAll)){
if($row["news_id"] == $id){
break;
}
$ii++;
}

//上一筆
if($ii > 0){
mysql_data_seek($RecNewsAll, $ii-1);
$row1 = mysql_fetch_array($RecNewsAll);

}
//下一筆
if($ii < mysql_num_rows($RecNewsAll)-1){
mysql_data_seek($RecNewsAll, $ii+1);
$row2 = mysql_fetch_array($RecNewsAll);
}

//=======================================================