Okay, so, this script generates links and limits the results, but for some reason when I try to view past posts, nothing shows up. Help?

<?php
include('sources/connect.php');
$pagenum = 1;
$postperpage = 3;

if(isset($_GET['id'])) {
$id = $_GET['id'];
$query = "SELECT title, text FROM posts WHERE Id=$id";
$result = mysql_query($query);
    while ($row = mysql_fetch_array($result)){
    ?>
    <div class='post' id='post'>
    <div class='meta'>
    Posted by <a href='http://www.deadlyclever.com'>Corey</a>
    </div>
<h2><?php echo $row['title']; ?></h2>
<p><?php echo $row['text']; ?></p>
</div>
    <?
    }
}

elseif(isset($_GET['page'])){
$pagenum = $_GET['page'];
}

else{

$offset = ($pagenum - 1) * $postperpage;

$query = " SELECT id, title, text FROM posts " . " LIMIT $offset, $postperpage " . " ORDER BY id DESC ";

$result = mysql_query($query) or die("SQL Query failed ...");

  while ($row= mysql_fetch_array($result)) {
?>
    <div class='post' id='post'>
    <div class='meta'>
    Posted by <a href='http://www.deadlyclever.com'>Corey</a>
    </div>
<h2><a href='index.php?id=<?php echo $row['id']; ?>'><?php echo $row['title']; ?></a></h2>
<p><?php echo $row['text']; ?></p>
</div>
<?

}


$query = " SELECT title, text FROM posts ORDER BY id DESC ";

$numresults = mysql_query($query) or die('Error, query failed');
$numrows = mysql_num_rows($numresults);
$maxpage = ceil($numrows/$postperpage);
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxpage; $page++)
{
    if ($page == $pagenum){
    $nav .=" $page "; 
    }
    else {
    $nav .=" <a href=\"$self?page=$page\">$page</a> ";
    }
}
if ($pagenum > 1)
{
   $page  = $pagenum - 1;
   $prev  = " <a href=\"$self?page=$page\">[Newer]</a> ";

   $first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
   $prev  = '&nbsp;'; // we're on page one, don't print previous link
   $first = '&nbsp;'; // nor the first page link
}

if ($pagenum < $maxpage)
{
   $page = $pagenum + 1;
   $next = " <a href=\"$self?page=$page\">[Older]</a> ";

   $last = " <a href=\"$self?page=$maxpage\">[Last Page]</a> ";
}
else
{
   $next = '&nbsp;'; // we're on the last page, don't print next link
   $last = '&nbsp;'; // nor the last page link
}

if($numrows == 0)
{
echo "<h4>There is no news found...</h4>";
}
}

// print the navigation link
echo $prev . $next;

require_once('sources/disconnect.php');
?>

Are you using output buffer's?
If you are put the following at the end of your code:

PHP Code:

ob_flush(); 


Originally Posted by rogem002

Are you using output buffer's?
If you are put the following at the end of your code:

PHP Code:

ob_flush(); 


I don't know what an output buffer is. Honestly, I barely understand this code. I used a tutorial and got the basic concepts.

Just looking at the code, I see one strange thing; the query:

$query = " SELECT id, title, text FROM posts " . " LIMIT $offset, $postperpage " . " ORDER BY id DESC ";

The LIMIT x, y is a shortcut, but I believe it should by LIMIT {how many}, {from position}.
Which would convert to

$query = " SELECT id, title, text FROM posts " . " LIMIT $postperpage, $offset " . " ORDER BY id DESC ";

Or, with the full SQL syntax:

$query = " SELECT id, title, text FROM posts " . " LIMIT $postperpage OFFSET $offset " . " ORDER BY id DESC ";

I'm afraid that didn't really fix anything...

Can you send me your database structure too so that I can check the script

Here is the structure of the table. It's saved as a .txt file.