I think it would probably be better to read all the id's into an array, and then use the array stepping functions to move forward or back. This way, you won't have to worry about "empty" rows, or id's that are not numerically following on each other.
On Thu, 2002-09-05 at 23:20, tux wrote: > > hey all, > > if im displaying pages with data from a database eg > > www.domain.com/file.php?id=40 > > on that page i would like to have a previous and next link that would > take it to id 41 and 39 respectively, the only problem being what if 39 > or 41 was empty? then i would want the link to be id=42 or id=38.. is > the best way to do this just loop through the id's until it finds a > entry that isnt empty? or is there any functions for this? > > jo > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php