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