How to take second 10 values ​​from db?

Question

PHP

Hello. I have never worked with pages in PHP.
I want to make 5 pages and place 10 elements on each.

#php code...

#здесь я беру первые 10 страниц
$first_page= acc("SELECT * FROM `list` ORDER BY `id` DESC LIMIT 10");
#теперь вопрос, как мне взять вторые 10 страниц, третьи, и тд?

Answer 1

$first_page= acc("SELECT * FROM `list` ORDER BY `id` DESC LIMIT 10 OFFSET 10");

Everything is in the documentation
https://dev.mysql.com/doc/refman/8.0/en/select.html

[LIMIT {[offset,] row_count | row_count OFFSET offset}]