Paging

[SP8600]

Hi, the problem i have is that i want to select feilds from my MySQL database but only want to display about 10 per page but there will be more brought back than that so i would like to have it so it splits them down in to pages so u just have to press the "next" link to display the next 10 items. Does anyone know or have any code i could have a look at to do this.

Thanks loads,
Darren

[ereptur]

if (isset($_GET["min"]))
    $min = $_GET["min"];
else
    $min = 0;

$query = "select id,field1,field2 from table where id>$min limit 10";
$result = mysql_query($query);

$nextset = $min + 10;
$prevset = $min - 10;

while (list($id,field1,field2) = mysql_fetch_array($result)) {
   // This is just your output
   print "$id,$field1,$field2";
}
print "<a href=\"$PHP_SELF?min=$prevset\">Previous Page</a>&nbsp;&nbsp;&nbsp;<a href=\"$PHP_SELF?min=$nextset\">Next Page</a>";