How implement Next and Previous buttons?

[Lauj]

I'm creating a photo gallery. The file name and path to the file are all stored on MySQL database. Once I receive an ID on which thumbnail the user click, I display the full image on the page. I got the display worked out but I want to implement the Next and Previous button on this page so the user can click on these two buttons to move around instead of going back to the thumbnails. Once there is no next or previous picture, I want to disable the button. How do I go about doing this?

Any help is appreciated!

ljCharlie

[ropic]

Use adodb for db connections, it has a handler for pagination.

[Lauj]

Thanks for the response but I'm not looking for pagination. I want to determine the position of the picture that the user click so I can determine if the picture that is dispalyed in full size is the last picture or not.

ljCharlie

[bodzan]

You might be able to do this via key or via name of the pic...

Show us how is your data in db presented...