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>";
exit(1);
}
$x = ($num_rows/4);
$y = intval($x);
if ($x > $y)
{
$num_pages= $y+1;
}
else
{
$num_pages= $x;
}
$curr_row = ($curr_page*4);
if ($DEBUG > 0)
{
echo "Curr_row is: $curr_row<br>";
}
mysql_data_seek($result, $curr_row);
HTH
-Brad
"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
