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