Dividing Query Results into Different Pages

[dana22b]

Hello Guys!

How are you?

Well, I have built a MySQL database using PHP with approximately 100
products.Whenever I run a query to see all the product names and
prices with a link to see the details, the query returns the full list of
available products in a long single page. What do you recommend that I
do for the results to be divided into separate pages after each 25 rows?
Something more like:

"Search Results: 100 products

Page 1 : (1-25)
Page 2: (26-51)"
etc.

Is there a special keyword or technique to follow for that?
Or, can you refer me to a tutorial article on that?

I would really appreciate your help!

Thanks,

Dana22b.

[LiamW]

You'll need to look into paginating your results.

This is an OOP way of doing it. (actual code is a few pages in)

This is a standard way of doing it.

Good luck.