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

I am using a PHP code to retrieve database content.

It works, I have impressed myself :)

However, I do not know how to tell the database to only display 8 products on a page. 4 on the top row, and 4 on the bottom.

The next 8 results would need to appear on another page.

Can anyone help me with how to do this.
Thanks so much,
Tom.
 
Back
Top