PHP MySQL problem

[PeejAvery]

Pagination is a very simple task. The following should get you through it.

<?php
$show = 10;
$page = (isset($_GET['page'])) ? $_GET['page'] : 1;
$page--; // because databases start at zero, humans start at one
$start = $page * $show;

$query = "SELECT * FROM blog ORDER BY date DESC LIMIT $start, $show";
$sql = mysql_query($query);
$rows = mysql_fetch_object(mysql_query("SELECT FOUND_ROWS() AS `rows`"))->rows;
while ($row = mysql_fetch_object($sql)) {
  // do your outputting from the database here
}

if ($page > 0) {echo '<a href="?page=' . $page . '">&lt;&lt; Newer Posts</a>';}
$total = ceil(mysql_num_rows(mysql_query("SELECT id FROM blog")) / $show);
if ($page < $total - 1) {echo '<a href="?page=' . ($page + 2) . '">Older Posts &gt;&gt;</a>';}
?>