Posted by Anze on 09/21/05 20:15

Hi Jon!

This is not a nice way, but it would work. You'll have to use your field
names, of course, but the principle is easy...

Next id:
'SELECT min(id) FROM table WHERE id>'.$currentId

Previous id:
'SELECT max(id) FROM table WHERE id<'.$currentId

Have fun!

Anze

[Back to original message]