Web lists-archives.com

Re: How to retrieve next record?

On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 <trianon33@xxxxxxxxx> wrote:
> Hi all,
> It seems like a simple question, however I'm not able to find the
> answer.....
> Let me explain. I have a DB with lots of columns, one is labeled as
> 'kenteken' and it is also the primary key in the DB. I poke into this DB
> with the command
> $sDBQuery1 = "SELECT * FROM kentekenlogtest WHERE kenteken =
> '$sActueelkenteken'";
> This is ok and gives me the correct result. However, then I want the next
> row (according to the primary key), but with what command?
> That's were I'm stuck.
> Didn't find anything like NEXT, so... what to look for?

What do you mean by 'next' row? Since you're querying by primary key
you will only get one row, right?

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql