From: Michael Widenius
Date: March 14 1999 12:42pm
Subject: Re: Navigation Through DB
List-Archive: http://lists.mysql.com/mysql/221
Message-Id: <14059.44678.158728.728164@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Kevin" == Kevin P O'Brien <kevino@stripped> writes:

Kevin> Thanks Tim.
Kevin> The Last syntax works.

Kevin> This is what I have for Next

Kevin> if ($FORM{'next'})
Kevin> {
Kevin> $next = $FORM{'TNum'};
Kevin>     $sth=$dbh->query("SELECT * FROM Tickets LIMIT @{[$next + 1]}, 1");
Kevin>     &Display
Kevin> }

Kevin> When I print $next before the query it holds the current TicketNumber.
Kevin> Although, I am sure the syntax for the query is incorrect.

In this case you should do:

"SELECT * FROM Tickets WHERE TicketNumber > $next LIMIT 1"

(The above should be very efficient)

Regards,
Monty