I did something like this with a photo gallery I made.  The approach I took is
the execute a query, get the number of rows, and divide that number by how ever
many records I wanted on that page.  Then that would give me the number of total
pages I would have for my navigational links at the bottom.  Then I would pass a
page number from page to page and multiply this by the number of records which
would give me the first record to display from the same query.  Soem sample
code:  (I displayed 4 pictures/records per page)
$num_rows = mysql_num_rows($result);

//Check to see if any rows are present
if ($num_rows <= 0)
    echo "<center><h2>No Pictures Available in this Album</h2></center>";
$x = ($num_rows/4);
$y = intval($x);
if ($x > $y)
    $num_pages= $y+1;
    $num_pages= $x;
$curr_row = ($curr_page*4);

if ($DEBUG > 0)
    echo "Curr_row is: $curr_row<br>";
mysql_data_seek($result, $curr_row);


"Lucas Novæ Matrix" wrote:

> Hello,
> I am trying to create a "next n" interface through php4, using results from
> a mysql query. I did this in the past easily with ColdFusion, but this time
> it's a bit more complicated.
> What I need to do basicaly is to have only 5 results per page. The first
> page displays the 5 results and "Next Page >>>" at the bottom, the second
> page displays results 6 to 10 and displays "<<< Previous Page | Next Page
> >>>" , up until the last page that displays only the previous page, and the
> last results (from 1 to 5).
> I don't necessarely need to have each page as a number at the bottom, just
> the previous and next links. All I need basically is to either get or output
> only 5 rows at a time, with only needing the $_GET['startrow'] variable.
> Can anyone help me? (or just throw me a link to an existing page/script)
> Thanks,
> Éric.
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to