Re: Next N Interface

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