From: Thimble Smith
Date: March 12 1999 6:30pm
Subject: Re: Navigation Through DB
List-Archive: http://lists.mysql.com/mysql/145
Message-Id: <19990312113005.T28088@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Fri, Mar 12, 1999 at 09:43:23AM +0000, Kevin P. O'Brien wrote:
> I need to know the syntax in the perl script to call --> First,
> Last, Next, Previous --> Record

This is a long answer.  Unfortunately I don't have any example
code to show you.  It all depends on how you're calling your
CGI script, what your selects look like, etc.

But:  You'll want to use LIMIT in your queries; you can use
ORDER BY ... DESC LIMIT 1 to get the last record.  To get Next
and Previous, you need to store which record you're looking at
(pass it as a hidden variable in your HTML form) and then do
something like ... LIMIT @{[$current_record + 1]}, 1 (for Next).

Tim