splitting up results

I have a large database and would like to split the results into 20 per page and with arrows to go to the next page and numbers to skip pages. But I'm not sure how to do it. I know I've seen an article on how to do this somewhere, anyone know one about this?

One possible way is to execute the query and use mysql_affected_rows ($retrieved=mysql_affected_rows($link)) to see how many rows were returned from it. Then use MySQL's limit in the query for each successive page.

If 144 rows were returned from the original query and this is stored in the $retrieved variable....

$increment=20;

if(empty($currval)) // this is the first query
{
$currval=0;
$query="select * from table limit $increment";
}
else // all subsequent queries
{
$currval+=20;
$query="select * from table limit $currval, $increment";
}

.
.
.
query output
.
.
.

if($currval < $retrieved)
{
print"<a href="search.php3?currval=$currval&retrieved=$retrieved">See next results</a>";
}

...limit 20 will give you the first 20 rows returned from query

...limit 20, 20 will return twenty rows starting with the 21st row

...limit 40, 20 will give 41 through 60 and so on

This is rough codestimate, but it may be able to help