MySQL Query to select previous and next product

Hi, all

I am developing a website for a some sports wears etc… it has a page that shows products as thumbnails. when a thumbnail is clicked its detail pages is shown with large image. that was intro for website.

example page can be accessed here
[URL=”http://www.turabinternational.com/test-large-1.html”]http://www.turabinternational.com/test-large-1.html[/URL]

I want to add two links for previous and next products but for that i need the ‘id’ for both previous and next…

how can it be done ???

Also in #PHP _↴