finding next and prev record in mysql
| From: | Richard Kurth | Date: | Fri, 11 May 2007 04:54:01 +0000 |
| Subject: | finding next and prev record in mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-254779@lists.php.net to get a copy of this message | ||
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