Help me show 5 rows per page!!!

[cosmo7]

Can someone please show me how to build this loop so it will show me only 5 rows at a time with the NEXT and PREVIOUS page links?

$num = mysql_numrows($result);

<? while ($i < $num) { 

$picture=mysql_result($result,$i,"picture");
$row_color = ($row_count % 2) ? $color1 : $color2; 
?> 

<td bgcolor="<? echo "$row_color" ?>" align="center"><dd><font face="Arial, Helvetica, sans-serif"><a 
href="large.php?picture=<? echo "$picture"; ?>" 
onclick="NewWindow(this.href,'name','500','275','no');return false;"><img 
src="/thumbnails/<? echo "$picture"; ?>+.jpg" border="1"</font> 
</dd><br></td> 

<? 
++$i; 
if ($i % 3 == 0) { 
print "</tr><tr>"; 
$row_count++;
} 

} 
?>

-All the variables that seemingly are not defined, ARE defined.
I just posted the loop that generates my table.
-The "row_count" variable is for the purpose of alternating row colors... so... don't get mixed up...🙂

[Duey]

there is a tutorial on how to do this here:
http://www.spoono.com/tutorials/php/nextprev/

[PHP-Editors_com]

If you think about it, its really just a matter of keeping track of a variable for the LIMIT() clause in your SQL. First you decide how many records per page, and the tracking number of how many records you have already shown. Use these 2 numbers to build you SQL - LIMIT (20, 5) if already shown 20 records and showing 5 per page. Pass the '20' value using a query string like this: page.php?count=20. You get the picture... Its these type of things that keep programming intresting !!