pagination code - critique

[kpowning]

I have the following pagination code and I was wondering if anyone has any improvements that I could add or edit to this??

$max_results = 3; //edit the number of results you want to display

$page = (!isset($_GET['page']))? 1 : $_GET['page'];
$prev = ($page - 1); 
$next = ($page + 1); 

$from = (($page * $max_results) - $max_results); 
$result = $DB_site->query_first("SELECT COUNT(username) as ttl FROM " . TABLE_PREFIX . "user WHERE referrerid > 0"); 
$total_pages = ceil($result['ttl'] / $max_results);
$pagination = '';

if($page > 1) 
{ 
$pagination .= ' <a href="referrals.php?page='.$prev.'">Previous</a> '; 
} 

for($i = 1; $i < $total_pages; $i++) 
{ 
if(($page) == $i) 
{
$pagination .= $i; 
}
else
{ 
$pagination .= ' <a href="referrals.php?page='.$i.'"> '.$i.'</a> ';
} 
} 

if($page + 1 < $total_pages) 
{ 
$pagination .= ' <a href="referrals.php?page='.$next.'">Next</a> '; 
}

[Larry_Bigner]

Try making a re-useable portion, like this for example:

class Pager
{
function getPagerData($numHits, $limit, $page)
{
$numHits = (int) $numHits;
$limit = max((int) $limit, 1);
$page = (int) $page;
$numPages = ceil($numHits / $limit);

	$page = max($page, 1);
	$page = min($page, $numPages);

	$offset = ($page - 1) * $limit;

	$ret = &new stdClass;

	$ret->offset   = $offset;
	$ret->limit    = $limit;
	$ret->numPages = $numPages;
	$ret->page     = $page;

	return $ret;
}

}

$page = $_GET["page"];
$limit = 20;
$total = @mysql_num_rows( @( "select * from table where key=$value order by field desc" ) );

$pager = Pager::getPagerData( $total, $limit, $page );

if (1 == $pager->page);
else
$pages .= "<a href=\"$PHP_SELF?fid=$fid&amp;page=" . ($page - 1) . "\">Previous</a>";

for ($i = 1; $i <= $pager->numPages; $i++)
{
$pages .= " | ";
if ($i == $pager->page)
$pages .= "$i";
else
$pages .= "<a href=\"$PHP_SELF?fid=$fid&amp;page=$i\">$i</a>";
}

if ($page == $pager->numPages)
$pages .= " |";
else
$pages .= " | <a href=\"$PHP_SELF?fid=$fid&amp;page=" . ($page + 1) . "\">Next</a>";