Re: finding next and prev record in mysql
| From: | Chris | Date: | Fri, 11 May 2007 05:09:22 +0000 |
| Subject: | Re: finding next and prev record in mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-254780@lists.php.net to get a copy of this message | ||
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 lastnameAsk the mysql list: http://lists.mysql.com/ I'm sure they have been asked a similar thing many times in the past. -- Postgresql & php tutorials http://www.designmagick.com/