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
$max_display = 1; // show one record at a time
// first do a select of all records to get mysql_numrecs and assign
to $num_recs
// then get the current record
$sql = "select * from $table LIMIT $first_rec,$max_display";
...
$next = $first_rec+1; $prev_rec=$first_rec-1;
$this_rec = $next; // same record number as current, except 1-based
echo "<a href='file.php?first_rec= $prev_rec'>Previous</a>
Showing $this_rec of $num_recs<a
href='file.php?first_rec=$next'>Next</a>";
HTH
On Thursday, May 16, 2002, at 08:32 AM, Natividad Castro wrote:
> Hi to all,
> how do I move through a recordset? For example, if I have 4 records
> and I
> want to display one at a time and let the user to click a MoveNext
> button to
> go to the next record or a Previous button to go to the Previous record.
>
> Thanks in advanced
> Nato
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Terry Romine
Web Developer
JumpInteractive.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
