I am afraid that you are mistaken. The syntax that you have just provided:

	select <something> from <somewhere> limit n, x

	where n is 20 and x is 40

will NOT give you rows 20 through 40... if you look at http://www.mysql.com/Manual_chapter/manual_Reference.html#SELECT in the mysql reference you will see that it states that the limit mechanism is:

	limit offset, rows

in order to receive rows 20 through 40 the proper limit syntax would have been:

	limit 20, 20

thank you.