Re: Previous | Next (Again)

Hi! Don't use the ID to count prev or next image. Use the $offset variable instead. $result=mysql_query("select id,name,phone ". "from TABLE where YOUR CONDITIONAL HERE ". "order by ID asc limit $offset,$limit"); Regards -- Shin "Jeff Oien" <jeff@webdesigns1.com> wrote in message news:PGEBKOPJJHHICHGDKCCIAEHADCAA.jeff@webdesigns1.com... > 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