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
- finding next and prev record in mysql Richard Kurth
- Re: finding next and prev record in mysql Brent Baisley
- RE: finding next and prev record in mysql Richard Kurth
- Re: finding next and prev record in mysql Baron Schwartz
- Re: finding next and prev record in mysql Mogens Melander
- Re: finding next and prev record in mysql Baron Schwartz
- RE: finding next and prev record in mysql Richard Kurth
- Re: finding next and prev record in mysql Baron Schwartz