Simple Next Page Pagnation MYSQLI

Simple Next Page Pagnation MYSQLI

Hi I'm trying to figure out if this will work in some sense. Right now of
course it's not. I'm throwing now errors, but I'm also not getting
anything outputting with the $nextLink variable..
Here is the full so we're clear how it all comes together:
<?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';
}
}
?>
and here is the snippet I'm working through.
$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';
}
}
I'm trying to select the next row by grabbing the bunch after current id
and picking the next one to feed the $nextLink for the the HTML.
This was my vardump for $next
object(mysqli_result)#3 (5) {
["current_field"]=>
int(0)
["field_count"]=>
int(10)
["lengths"]=>
NULL
["num_rows"]=>
int(0)
["type"]=>
int(0)
}