Use the LIMIT command in MySQL
William R. Lorenz - Wed, Nov 10, 1999 at 09:37:31AM -0500
> 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.
--
Geoff Crawshaw
CTO
TimeBills.com Inc.
[EMAIL PROTECTED]
http://www.timebills.com
