List:General Discussion« Previous MessageNext Message »
From:Kevin P. O'Brien Date:March 12 1999 11:25am
Subject:Re: Navigation Through DB
View as plain text  
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 <kevino@stripped>
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


Thread
Navigation Through DBKevin P. O'Brien12 Mar
  • Re: Navigation Through DBThimble Smith13 Mar
Re: Navigation Through DBKevin P. O'Brien13 Mar
  • Re: Navigation Through DBMichael Widenius15 Mar
Re: Navigation Through DBKevin P. O'Brien13 Mar