Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Solution - Re: Building an index for next/last in a photo album.

by valdez (Monsignor)
on Jul 27, 2004 at 14:52 UTC ( [id://377753] : note . print w/replies, xml ) Need Help??


in reply to Solution - Re: Building an index for next/last in a photo album.
in thread Building an index for next/last in a photo album.

Your solution is quite general, but I don't like the idea of retrieving all the records every time I need to build next and previous links in a page; why don't you use the LIMIT/OFFSET clause available under PostgreSQL and MySQL?

Ciao, Valerio

  • Comment on Re: Solution - Re: Building an index for next/last in a photo album.