elk dolk wrote:

Chris <[EMAIL PROTECTED]> 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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to