Hi,

Giving page=15 is a "direct" method by which you can use the argument "page" directly with LIMIT. If you are passing pages as 0, 1, 2, 3 you can multiply it with 15. If its starting with 1, multiply page-1 with 15. Your perl script may look like

my $q       = new CGI;
my $page    = $q->param("page") || '0'; #default 0
my $count   = $q->param("count") || 15; # more flexibility. you can pa
+ss the No of records as count :), defaults to 15

$offset = $page * count; # assumes that page no starts with 0.
#$offset = ($page-1) * count; # assumes that page no starts with 1. Co
+mment previous line and uncomment this if you wish to start page from
+ 1

$SQL = "SELECT * FROM your_table ORDER BY id LIMIT $offset, $count";

...
<rest of your code>
...
[download]

Cheers !

--VC