简单的下一页分页MYSQLI

嗨，我正试图弄清楚这在某种意义上是否可行。现在当然不是。我现在抛出了错误，但也没有得到任何带有$nextLink变量的输出。。

这是完整的，所以我们很清楚这一切是如何结合在一起的：

<?php
// Check to see the URL variable is set and that it exists in the database
if (isset($_GET['id'])) {
// Connect to the MySQL database
include "includes/db_conx.php";
$id = intval($_GET['id']);// filter everything but numbers
// Use this var to check to see if this ID exists, if yes then get the product
// details, if no then exit this script and give message why

$sql = "UPDATE content SET views=views+1 WHERE ID=$id";
$update = mysqli_query($db_conx,$sql);
$sql = "SELECT * FROM content WHERE id=$id LIMIT 1";
$result = mysqli_query($db_conx,$sql);
$productCount = mysqli_num_rows($result);
//

if ($productCount > 0) {
// get all the product details
while($row = mysqli_fetch_array($result)){
$id = $row["id"];
$article_title = $row["article_title"];
$category = $row["category"];
$readmore = $row["readmore"];
$author = $row["author"];
$date_added = $row["date_added"];
$article = $row["article"];
$newDate = substr($date_added, 0, 10); 
}
} else {
echo "That item does not exist.";
exit();
}
} else {
echo "Data to render this page is missing.";
exit();
}
$sqltwo = "SELECT * FROM content WHERE id =(select min(id) from content where id > '$id') LIMIT 1";
$next = mysqli_query($db_conx,$sqltwo);
if($next > 0){
while($row = mysqli_fetch_array($next)){
$id = $row["id"];
$nextLink = '$id';
}
}
?>

这是我正在处理的片段。

$sqltwo = "SELECT * FROM content WHERE id =(select min(id) from content where id > '$id') LIMIT 1";
$next = mysqli_query($db_conx,$sqltwo);
if($next > 0){
while($row = mysqli_fetch_array($next)){
$id = $row["id"];
$nextLink = '$id';
}
}

我正试图选择下一行，方法是抓取当前id之后的一堆，然后选择下一个来为HTML提供$nextLink。

这是我下一个的vardump

object(mysqli_result)#3 (5) {
  ["current_field"]=>
  int(0)
  ["field_count"]=>
  int(10)
  ["lengths"]=>
  NULL
  ["num_rows"]=>
  int(0)
  ["type"]=>
  int(0)
}