Hey guys heres what im doing basically...
I have a database with 3 columns: picturename, folder, description
What I am trying to do is allow users to "scroll" through the pictures one at a time. Like this http://www.gotkarma.net/cottage/pages/DSC_2845.html where the user can hit the left arrow to go back, right arrow to go right or up to go back to the pictures listing.
I would like to do the following, sort the database in ASC order according to folder and then picturename and then determine the db entry (in alphabetical order) before the current one and the one after.
Basically the since the camera resets (I delete the pictures) for each folder I need to see what is next to the current picture in line that is also contained in the same folder.
