On Thu, May 10, 2007 11:54 pm, 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
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 10, 2007 10:09 PM
To: Richard Kurth
Cc: php-general@lists.php.net
Subject: Re: [PHP] finding next and prev record in mysql
Richard Kurth wrote:
How would I find the next id and the prev id in sql statement
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 10, 2007 10:09 PM
To: Richard Kurth
Cc: php-general@lists.php.net
Subject: Re: [PHP] finding next and prev record in mysql
Richard Kurth wrote:
How would I find the next id and the prev id in sql statement
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
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 lastname
5 matches
Mail list logo