The query is:

SELECT * FROM `news` ORDER BY `id` LIMIT ($curr_page * 5), ( ($curr_page * 5) + 5 )

Where $curr_page is a php variable which is getting a value from $_GET['page']

I want to make a pagination (5 news on each page), but I don't know why the mysql is returning me extra values.

On the first page the result ok: $curr_page = 0

The query would be:

SELECT * FROM `news` ORDER BY `id` LIMIT 0, 5

But on the second page, the result from the query is adding extra news, 10 instead of 5.

The query on the second page:

SELECT * FROM `news` ORDER BY `id` LIMIT 5, 10

Whats wrong? Why the result has 10 values instead of 5?

Thank you!