sorry about formatting. exactly how would I get $previd and $ nextid from mysql database.I already scale the pictures and compress on upload.I can already display all of the images as buttons on one generated page (cgi.pm) what I am trying to do is when a user clicks on a thumbnail image he activates (using onclick event ) clickable slide show with next,prev,exit links.