Having trouble with PHP Pagination

[jukrzy]

Hello, Here is the code I'm currently using. When I click next, the page just reloads and the same content is still being displayed. I will break it down from PHP to HTML.

$maxRows_getRecent = 8;
$pageNum_getRecent = 0;
if (isset($_GET['pageNum_getRecent'])) {
  $pageNum_getRecent = $_GET['pageNum_getRecent'];
}
$startRow_getRecent = $pageNum_getRecent * $maxRows_getRecent;

mysql_select_db($database_XXX, $XXX);
$query_getRecent = "SELECT news.post_id, news.title, news.category, news.link, news.picture, news.preview FROM news WHERE news.category NOT IN (SELECT news.category FROM news WHERE news.category='random' )ORDER BY news.updated DESC";
$getRecent = mysql_query($query_getRecent, $XXX) or die(mysql_error());
$row_getRecent = mysql_fetch_assoc($getRecent);
$totalRows_getRecent = mysql_num_rows($getRecent);

if (isset($_GET['totalRows_getRecent'])) {
  $totalRows_getRecent = $_GET['totalRows_getRecent'];
} else {
  $all_getRecent = mysql_query($query_getRecent);
  $totalRows_getRecent = mysql_num_rows($all_getRecent);
}
$totalPages_getRecent = ceil($totalRows_getRecent/$maxRows_getRecent)-1;

$queryString_getRecent = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_getRecent") == false && 
        stristr($param, "totalRows_getRecent") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_getRecent = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_getRecent = sprintf("&totalRows_getRecent=%d%s", $totalRows_getRecent, $queryString_getRecent);
?>

There is the PHP.
Here is the HTML.

 <?php do { ?>
          <article>
          <div id="picture"><a href="<?php echo $row_getRecent['post_id']; ?>/<?php echo urlencode($row_getRecent['title']); ?>.html"><img src="<?php echo $row_getRecent['picture']; ?>" width="250" alt="" /></a>
<div id="category"><h2 id="cat"><a href="<?php echo $row_getRecent['category']; ?>.php"><?php echo $row_getRecent['category']; ?></a></h2></div></div>
          <div id="info">

          <h1 id="title"><a href="<?php echo $row_getRecent['post_id']; ?>/<?php echo urlencode($row_getRecent['title']); ?>.html"><?php echo $row_getRecent['title']; ?></a></h1>
          <p><?php echo $row_getRecent['preview']; ?></p>
          <div id="commentlink"><h6><a href="fetch.php?id=<?php echo $row_getRecent['post_id']; ?>#disqus_thread">Link</a></h6></div></div></article>

          <?php } while ($row_getRecent = mysql_fetch_assoc($getRecent)); ?>

<div id="paging">
    <div class="page"><?php if ($pageNum_getRecent > 0) { // Show if not first page ?>
        <a href="test.php?id<?php printf("%s?pageNum_getRecent=%d%s", $currentPage, 0, $queryString_getRecent); ?>">First</a>
        <?php } // Show if not first page ?></div>


    <div class="page"><?php if ($pageNum_getRecent > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_getRecent=%d%s", $currentPage, max(0, $pageNum_getRecent - 1), $queryString_getRecent); ?>">Previous</a>
        <?php } // Show if not first page ?></div>


    <div class="page"><?php if ($pageNum_getRecent < $totalPages_getRecent) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_getRecent=%d%s", $currentPage, min($totalPages_getRecent, $pageNum_getRecent + 1), $queryString_getRecent); ?>">Next</a>
        <?php } // Show if not last page ?></div>

    <div class="page"><?php if ($pageNum_getRecent < $totalPages_getRecent) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_getRecent=%d%s", $currentPage, $totalPages_getRecent, $queryString_getRecent); ?>">Last</a>
        <?php } // Show if not last page ?></div>
  </div>

This is what I have at the moment. I would like to be able to create paging for this but not have the entire page reload if that is at all possible. To have only a section of the page refresh as it scrolls through the pages. I would like to give my thanks in advance and if you need more information from me please don't hesitate to ask. I will give you more code or information as needed. Thank you.

[jukrzy]

Hello, I seemed to have solved my problems by rewriting my sql queries. I really don't know what was wrong with it to begin with.