Re: Jumping to prev and next records

2004-03-16 Thread Hans-Peter Grimm
Scott Haneda wrote: [...] Is perhaps there some way to get the next id and prev id in a mysql query based on id being sorted? You could do this using LIMIT. For example: SELECT id FROM foo WHERE id > $current_id ORDER BY id ASC LIMIT 1; SELECT id FROM foo WHERE id < $current_id ORDER BY id DESC LI

Jumping to prev and next records

2004-03-15 Thread Scott Haneda
I know I can do this in code, but was wondering if I am overlooking something in the docs about it. Table images --- Id url Currently, I show a simple list on a page where one can click on the image and it pops open a new window and loads url as a img src. I have been as