Re: [htmltmpl] resultset Paging and Row limitation

[Sam T. <sa...@tr...>]

On Sun, 4 Feb 2007, Massoud Kohan wrote:

> I am new to the Html-template and perl.
> How can I show the resultset to the web page which Shows 10
> records per page and also page numbers on the bottom of the
> table?

HTML::Pager was designed to do this for you.  It's a little tricky to
use, but you can study the code if you just want to see an example of
how it's done.

For the database side of things, be sure to use LIMIT and OFFSET to
get your data-set back from MySQL.  Selecting everything like you're
doing now is going to be very slow for large lists.

-sam