next and previous record from table

[lucky7]

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 --

[hannah]

Hi mate
Add another column to the table, make it auto_increment and then use that to determine the previous/next image.
Good day -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[matthew]

You have to have primary key in your table and then you can do something like

PHP Code:
while ($row = mysql_fetch_row($result))
{
$thisId = $row["Id"];
}

$lastId = $thisId - 1;
$nextId = $thisId + 1;

and if you want to select complete records of next and prev ids then write queries based on last and next ids vars,

PHP Code:
select * from tb where id=$lasdId
select * from tb where id=$nextId -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[acerman]

If you have IIS installed locally you should be able to type
http://localhost/..... to connect. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --