At 09:37 10-11-99 -0500, William R. Lorenz 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.
You can use the LIMIT clause, which works wonders for this.
Grtz,
Pascal
