Re: How to retrieve next record?
- Date: Thu, 11 Dec 2014 14:07:33 -0800
- From: "Wm Mussatto" <mussatto@xxxxxxx>
- Subject: Re: How to retrieve next record?
On Thu, December 11, 2014 13:43, Larry Martell wrote:
> 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
>> 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 =
>> This is ok and gives me the correct result. However, then I want the
>> 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?
Related what is the form of the prmary key. If its numeric something like
$sDBQuery1 = "SELECT * FROM kentekenlogtest WHERE kenteken <
'$sActueelkenteken' limit 1"
William R. Mussatto
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql