The doc explains very well how it works. All you have to do is add a pager div to the existing tablesorter object.
As for the DB question, you pull all the data once, and the pager plugin does the magic for you. On Oct 19, 7:56 am, Bhaarat Sharma <[EMAIL PROTECTED]> wrote: > Hi > > is there a good table pagination plugin out there that explains how to > use it as well? I came across this example but it doesnt explain how > to use it :(http://tablesorter.com/docs/example-pager.html > > it just shows this snippet > > $(document).ready(function() { > $("table") > .tablesorter({widthFixed: true}) > .tablesorterPager({container: $("#pager")}); > > }); > > If we were getting data from a DB...will we just do a one call to the > DB and then this plugin will page thru the results? or on every time > user hits next, this plugin has to call the DB? > > appreciate if someone could explain this plugin a bit ...or know an > article that explains it. > > Thanks