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