Building next/prev links

[eluser]derekt[/eluser]
Thanks xwero; I agree. I'm trying to do <3 db hits on each page if possible, so I'm kinda wondering if I need to pull the filename column of my db into a numeric array in the controller, then increment or decrement the array index value to retrieve the appropriate filename. It just really seems like there should be a neater way to do this...