I have the following:

SELECT id, title FROM pictures WHERE id='$pic'
Now that shows the picture, how can I creat a pagination thing of this so under each picture I have have a next and previous link so that it shows the next and previous pictures in the database.

This means the next id up in the table and the next id down in the table for the next and previous pagination thing.

Please help!