in reply to Re: View 100 then click for rest
in thread View 100 then click for rest

The first number in the LIMIT statement is the maximum number of records to return; the second is the record number to start at.

It's the other way round: first is offset, second is rows. (Offset starts at 0!)

In Section Seekers of Perl Wisdom