Php Database Code Php Code, Retrieving Database Information. How To Organise It?

Php code, retrieving database information. How to organise it? - php database code

I use a PHP code to be accessed, the contents of the database.

It works, I am impressed with myself:)

However, I do not know how to tell the database to display only 8 items on a page. Top 4 in the row and 4 in the background.

Next 8 results should be on a different page.

Can someone help how to proceed.
Thank you very much,
Tom.