Hi,
Richard Kurth wrote:
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Friday, May 11, 2007 9:25 AM
To: Mogens Melander
Cc: mysql@lists.mysql.com
Subject: Re: finding next and prev record in mysql
Mogens Melander wrote:
On Fri, May 11, 2007 07:15, Richard
limit 2,1 will give you the second record. It's the same query every
time, you're just incrementing the first number of the limit clause.
- Original Message -
From: "Richard Kurth" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 11, 2007 1:15 AM
Subject: finding next and pr
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Friday, May 11, 2007 9:25 AM
To: Mogens Melander
Cc: mysql@lists.mysql.com
Subject: Re: finding next and prev record in mysql
Mogens Melander wrote:
> On Fri, May 11, 2007 07:15, Richard Kurth wrote:
>>
Mogens Melander wrote:
On Fri, May 11, 2007 07:15, Richard Kurth wrote:
How would I find the next id and the prev id in sql statement like the one
below. The id number is not going to be in order so I can't do a < or >
limit 1 on the search
SELECT id FROM contacts WHERE category = '5' AND subca
On Fri, May 11, 2007 07:15, Richard Kurth wrote:
> How would I find the next id and the prev id in sql statement like the one
> below. The id number is not going to be in order so I can't do a < or >
> limit 1 on the search
>
> SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND
Hi,
Richard Kurth wrote:
How would I find the next id and the prev id in sql statement like the one
below. The id number is not going to be in order so I can't do a < or >
limit 1 on the search
SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND
members_id= '8' ORDER BY las
the limit
clause.
- Original Message -
From: "Richard Kurth" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 11, 2007 1:15 AM
Subject: finding next and prev record in mysql
How would I find the next id and the prev id in sql statement like the one
below. The id number is n
How would I find the next id and the prev id in sql statement like the one
below. The id number is not going to be in order so I can't do a < or >
limit 1 on the search
SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND
members_id= '8' ORDER BY lastname
