I am making a dynamic blog where it pulls posts from a SQL database and I tried to add some recordset navigation but it will not flip through the posts when I press 'next'.This is the coding for SQL part of this page:\[code\]mysql_select_db($database_blog, $blog);$query_getArchives = "SELECT DISTINCT DATE_FORMAT(news.updated, '%M %Y') AS archive, DATE_FORMAT(news.updated, '%Y-%m') AS link FROM news ORDER BY news.updated DESC";$getArchives = mysql_query($query_getArchives, $blog) or die(mysql_error());$row_getArchives = mysql_fetch_assoc($getArchives);$totalRows_getArchives = mysql_num_rows($getArchives);mysql_select_db($database_blog, $blog);$query_getRecent = "SELECT news.post_id, news.title FROM news ORDER BY news.updated DESC LIMIT 10";$getRecent = mysql_query($query_getRecent, $blog) or die(mysql_error());$row_getRecent = mysql_fetch_assoc($getRecent);$totalRows_getRecent = mysql_num_rows($getRecent);$maxRows_getDisplay = 10;$pageNum_getDisplay = 0;if (isset($_GET['pageNum_getDisplay'])) { $pageNum_getDisplay = $_GET['pageNum_getDisplay'];}$startRow_getDisplay = $pageNum_getDisplay * $maxRows_getDisplay;mysql_select_db($database_blog, $blog);$query_getDisplay = "SELECT news.title, news.pre, DATE_FORMAT(news.updated, '%M %e, %Y') AS formatted FROM news ORDER BY news.updated DESC";$query_limit_getDisplay = sprintf("%s LIMIT %d, %d", $query_getDisplay, $startRow_getDisplay, $maxRows_getDisplay);$getDisplay = mysql_query($query_limit_getDisplay, $blog) or die(mysql_error());$row_getDisplay = mysql_fetch_assoc($getDisplay);if (isset($_GET['totalRows_getDisplay'])) { $totalRows_getDisplay = $_GET['totalRows_getDisplay'];} else { $all_getDisplay = mysql_query($query_getDisplay); $totalRows_getDisplay = mysql_num_rows($all_getDisplay);}$totalPages_getDisplay = ceil($totalRows_getDisplay/$maxRows_getDisplay)-1;$queryString_getDisplay = "";if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_getDisplay") == false && stristr($param, "totalRows_getDisplay") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_getDisplay = "&" . htmlentities(implode("&", $newParams)); }}$queryString_getDisplay = sprintf("&totalRows_getDisplay=%d%s", $totalRows_getDisplay, $queryString_getDisplay);$var1_getDisplay2 = "-1";if (isset($_GET['archive'])) { $var1_getDisplay2 = $_GET['archive']; $query_getDisplay = sprintf("SELECT news.title, news.blog_entry, DATE_FORMAT(news.updated, '%%M %%e, %%Y') AS formatted FROM news WHERE DATE_FORMAT(news.updated, '%%Y-%%m') = %s ORDER BY news.updated DESC", GetSQLValueString($var1_getDisplay2, "text"));} elseif (isset($_GET['post_id'])) { $var2_getDisplay3 = $_GET['post_id']; $query_getDisplay = sprintf("SELECT news.title, news.blog_entry, DATE_FORMAT(news.updated, '%%M %%e, %%Y') AS formatted FROM news WHERE news.post_id = %s", GetSQLValueString($var2_getDisplay3, "int"));} else { $query_getDisplay = "SELECT news.title, news.blog_entry, DATE_FORMAT(news.updated, '%M %e, %Y') AS formatted FROM news ORDER BY news.updated DESC LIMIT 2";}$getDisplay = mysql_query($query_getDisplay, $blog) or die(mysql_error());$row_getDisplay = mysql_fetch_assoc($getDisplay);$totalRows_getDisplay = mysql_num_rows($getDisplay);\[/code\]and this is the recordset code:\[code\] <div id="blog_posts_container"> <h3><?php echo $row_getDisplay['title']; ?></h3> <p class="update">Posted on <?php echo $row_getDisplay['formatted']; ?></p> <div class="blog_entry" id="blog_posts"> <p><?php echo nl2br($row_getDisplay['blog_entry']); ?></p> </div></div> <?php } while ($row_getDisplay = mysql_fetch_assoc($getDisplay)); ?> <div id="blog_posts_container"> <table border="0"> <tr> <td><?php if ($pageNum_getDisplay > 0) { // Show if not first page ?> <a href="http://stackoverflow.com/questions/14048867/<?php printf("%s?pageNum_getDisplay=%d%s", $currentPage, 0, $queryString_getDisplay); ?>">First</a> <?php } // Show if not first page ?></td> <td><?php if ($pageNum_getDisplay > 0) { // Show if not first page ?> <a href="http://stackoverflow.com/questions/14048867/<?php printf("%s?pageNum_getDisplay=%d%s", $currentPage, max(0, $pageNum_getDisplay - 1), $queryString_getDisplay); ?>">Previous</a> <?php } // Show if not first page ?></td> <td><?php if ($pageNum_getDisplay < $totalPages_getDisplay) { // Show if not last page ?> <a href="http://stackoverflow.com/questions/14048867/<?php printf("%s?pageNum_getDisplay=%d%s", $currentPage, min($totalPages_getDisplay, $pageNum_getDisplay + 1), $queryString_getDisplay); ?>">Next</a> <?php } // Show if not last page ?></td> <td><?php if ($pageNum_getDisplay < $totalPages_getDisplay) { // Show if not last page ?> <a href="http://stackoverflow.com/questions/14048867/<?php printf("%s?pageNum_getDisplay=%d%s", $currentPage, $totalPages_getDisplay, $queryString_getDisplay); ?>">Last</a> <?php } // Show if not last page ?></td> </tr> </table> </div>\[/code\]It looks the same as my old page where the recordset navigation bar worked but for some reason it is not working now