Limiting size of a result set in mySql

[minestrone]

Hi,

I have a query that im using in a paginated page

e.g. "select * from news"

what i want to do is for the first page get the first 20 say and then for the second get from 21 to 40 and so on.

Is this possible in the query?

I can obviously code it up to do the logic in PHP but thats going to be inefficent and people might laugh at me behind my back.

Thanks,

David.

[thepeccavi]

just add "LIMIT {starting number}, {number to show}" to your query!

It is that easy!

[minestrone]

Cheers thepeccavi

thats the one, i shall now paginate without worry.