Look at setting up a couple of vars (I use $start_rec and $max_display)
and then use these to do a LIMIT on your SELECT statement.
Then use a link to go to next item or previous item. Pseudo code:
$first_rec = ($first_rec) ? $first_rec : 0; // if rec is passed in,
use it else start at 0
use count() to determine number of elements in the array. Then use the
returned result as an index to the last element.
Or, do you want to get to the last row of a result set from a mysql query?
In which case, go with:
$result = mysql_query(...)...
$rows = mysql_num_rows($result);
mysql_data_see