Re: Re: record pointer

elk dolk wrote:

Chris <dmagick@gmail.com> wrote: Huh? You want before, after and including? So everything? Maybe give us an example of what you want to get out of the query rather than us guessing. I keep the path to my photos in this DB so it is a photo Gallery , when I click on a thumbnail I want to see the image detail and then scroll to the next or previous photos with the same category.

Not a great query but see if this returns what you want: SELECT id, name, cat FROM table t2

    WHERE cat = (SELECT cat FROM table t1 WHERE id = $ID) AND (t2.id = t1.id - 1 OR t2.id = t1.id + 1);

I'm sure there's a much better way to do this however. -- Postgresql & php tutorials http://www.designmagick.com/