Pagination

<?php
//# of posts to display per page
$display = 5; 
 
//adds your page (if any) between like so '?{$uri}page=#'
$uri = "p=blog&";
 
//Get current page
$page = (!empty($_GET['page'])) ? $_GET['page'] : '0'; 
 
//Find post to start on, depending on page
$start = ($page == 0) ? $start = 0 : $start = (($page-1)*$display);
 
//Print content & count number printed
$query = "SELECT * FROM table LIMIT {$start},{$display}";
$result = mysql_query($query) or die(mysql_error());
$displayed = 0;
while($row = mysql_fetch_array($result)) {
	echo $row['content']."<br />";
	$displayed++;
} 
 
//Get number of total posts
$count = mysql_query("SELECT id FROM table");
$rows = mysql_num_rows($count);
 
//Get number of total pages
$pages = ceil($rows/$display);
 
//Make next/prev links
$next = $page+1;
$prev = $page-1;
 
//Unlink if next/prev doesn't exsist
$prevpage = ($prev == 0 || $prev == -1) ? 
"&lt;&lt; Prev" : "<a href='?{$uri}page={$prev}'>&lt;&lt; Prev</a>";
$nextpage = ($next < $pages+1) ? 
"<a href='?{$uri}page={$next}'>Next &gt;&gt;</a>" : "Next &gt;&gt;";
 
//Get showing from-to numbers
$from = $start;
$from = ($from == 0) ? 1 : $from+1;
$to = $start+$displayed;
 
//Print stats 
$page_num = ($page == 0) ? '1': $page;
echo "Showing entries {$from}-{$to}/{$rows}, 
on page {$page_num}/{$pages} <br /><br />";
 
//Print individual page number links
echo "{$prevpage} &nbsp; [";
$i = 1;
while($i != $pages+1) {
	//Print pages & add coma to all but last page #
	echo "<a href='?{$uri}page={$i}'>{$i}</a>";
	if($i != $pages) {echo ", ";}
	$i = $i+1;
}
echo "] &nbsp; {$nextpage}";
?>