You actually do want to use the limit clause, but use 2 parameters. The first number is which record you want to start at, the
second is how many records you want.
So 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
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
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
-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:
How would I
This good for giving me the next recorded but it will not give me the prev
recorded that is the one I am having problems with
You actually do want to use the limit clause, but use 2 parameters. The
first number is which record you want to start at, the second is how many
records you want.
So
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