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

[eluser]K-coder[/eluser]
@jrtashjian
Unfortunately i don't understand what does you mean exactly!

by the way, all i have is current id and it's coming from URL
http://sitename.com/product/details/5

and if i do something like pagination how can i get the current id to display the product details?

I know that it's complicated!



@Christophe28
this way make 3 queries and i think it's a lot because i have another 3 queries in same page

And yes i'm need something like navigation and not taking more than 1 query to get (previous, current and next) OR (previous and next) Only



Thanks guys for your help