Hello,
I have a table with data like this.....
Code:
ID Name
--- ------
3 James
1 Bill
6 Tom
5 Andy
2 John
4 Fred
What im tryin to do is figure a way to return the current record, along with the next and previous record IDs. For instance, if I were sitting on record with ID 6 then I want to grab also the next and previous IDs. Thing is, although the IDs are unique - they aren't sequential and there may be gaps.
Can anyone help with the best way of approaching this? It's basically for a gallery script. You preview thumbnails and when you click one it shows the full picture. While that picture is displayed, i'm after showing links to jump to the next or previous pictures without going back to the thumbnail page.
Thanks a lot
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --