Re: How to do Pagination With Perl and mySQL

If you're offering to post a Perl/MySQL tutorial I suggest you take a look at the advice described in tutorials, posting it in the Meditations section first (with "RFC" in the title). See also the existing Database Programming tutorials. Thanks.

Update: Belay that moderation, it's a SoPW post after all.

Comment on Re: How to do Pagination With Perl and mySQL

Replies are listed 'Best First'.
Re^2: How to do Pagination With Perl and mySQL by maicon1121 (Initiate) on Apr 30, 2012 at 17:27 UTC
Hello again, good afternoon. I think I just confused things with my terrible English. The truth is that I'm looking for a tutorial on how to create paging perl / mysql. If you have any material that could help me, would greatly appreciate it. Thank you.	[reply]
Re^3: How to do Pagination With Perl and mySQL by Anonymous Monk on Apr 30, 2012 at 21:10 UTC
The trick is putting `"LIMIT 10 OFFSET 20"` to the end of your queries. The first number will be how many items per page, and the second one is how many items to skip (i.e. pages * items_per_page)	[reply] [d/l]