How can i get ( previous, current and next) data from mysql records?

[eluser]K-coder[/eluser]
Hello,

I'm looking for smart solution to get previous, current and next data from database, for example in flickr.com you can go to next or previous photo by clicking on this photo

example: http://i53.tinypic.com/1s00hc.png

I can do something like that but it's going to make 3 queries in database and i'm looking for something optimize queries.