[SOLVED] Most effective way to paginate?

[unsider]

Obviously SQL pagination is the most effective, but is there a specific manner of coding which optimizes the pagination? Also if there's anything else you think I should know, let me have it

Below method very effective, or no...?

 

<?php
$query   = "SELECT COUNT(id) AS numrows FROM ....";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$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\">[Prev]</a> ";

$first = " <a href=\"$self?page=1\">[First Page]</a> ";
} 
else
{
$prev  = ' '; 
$first = ' '; 
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\">[Next]</a> ";

$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
} 
else
{
$next = ' ';
$last = ' '; 
}
echo $first . $prev . $nav . $next . $last;
?>

[.josh]

http://www.phpfreaks.com/tutorial/basic-pagination

[unsider]

:-X Oops, I'm sorry I haven't checked out the newly updated tutorial section since I've been back here, I didn't know we had one.

 

Thanks crayon.