From: Kevin P. O'Brien Date: March 12 1999 11:25am Subject: Re: Navigation Through DB List-Archive: http://lists.mysql.com/mysql/149 Message-Id: <199903121925.LAA09619@ark.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Thanks Tim. The Last syntax works. This is what I have for Next if ($FORM{'next'}) { $next = $FORM{'TNum'}; $sth=$dbh->query("SELECT * FROM Tickets LIMIT @{[$next + 1]}, 1"); &Display } When I print $next before the query it holds the current TicketNumber. Although, I am sure the syntax for the query is incorrect. Regards, Kevin P. O'Brien, MCP, CPST Systems Administration Irenyx Data Group, Inc. (Office) 1.250.334.9641 ext.239 (Fax) 1.250.334.2365 (Pager) 1.888.805.3820 (Toll Free) 1.800.275.4260 ext.239 PGP Public Key Fingerprint: 56C4 2F8C 5731 08C1 684D 05DC 05E5 697F