>>>>> "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