Previous | Next (Again)

From: Date: Fri, 31 Aug 2001 01:18:32 +0000
Subject: Previous | Next (Again)
Groups: php.db 
Request: Send a blank email to php-db+get-12012@lists.php.net to get a copy of this message
I'm having a hard time figuring this out. I have a photo album that displays one image at a time. I want to have Previous and Next links for images in a users album. This was suggested: http://www.phpbuilder.com/columns/rod20000221.php3 but it seems to be more for a number of results instead of one. At first I used the id field which is auto_increment and did -1 for previous +1 for next but then realized if they delete an image in the album the id field is no longer successive by 1. I can count the number of images in an album but not sure how to know which is the first, which is the second etc. and know which the current one is if the id field has gaps in it. Not sure if that made any sense. Jeff Oien

« previous php.db (#12012) next »