According to O'Reilly's 'MySQL & mSQL' page 255:
LIMIT [start,] rows
Returns only the specified numner of rows. If the start value is supplied,
that many rows are skipped before the data is returned. The first row is
numbered 0. e.g., SELECT url FROM links LIMIT 5,10 return URL's numbered
5 through 14.
(This is under the Reference entry for SELECT.)
Hope this helps.
darren
William R. Lorenz ([EMAIL PROTECTED]) wrote:
> ModPerl List,
>
> Forgive me if this is offtopic, but I am attempting to paginate a set of
> returned SQL records using mod_perl connecting to a MySQL server (through
> DBI/DBD::mysql). I believe this can be accomplished using the RANGE() SQL
> function, but to my knowledge it is not supported by MySQL.
>
> Does anyone have a proved method of separating results (1-10, 10-20, etc. -
> think of AltaVista returning search results and separating them into pages),
> using as little resources on the webserver as possible (would like to push
> most of the task to SQL server)? Thanks, in advance, for any assistance.
