Select - limit - PHPBuilder Forums

Select - limit

Hi,

I've got a problem with the limiting the number of results in an SQL query.

Right now I've got

SELECT * FROM news ORDER BY newsnr desc limit 10

This works fine - it shows the last 10 news stories.

But now I want to add a link for the Previous 10 news stories.

How can I select 11-20 instead of 1-10 of 1-20 ??

"LIMIT 11,10" should take 10, starting at the 11th one.