Jump to content

How can i limit amount of mysql results?


napap

Recommended Posts

How can i limit amount of mysql results?

Hi, i need som help with php and mysql. I am creating a search function for my websites, i am using a variable to hold the results of a mysql query, like this: $query = "SELECT * FROM database". then i am using a while statement to "echo" out the results...

 

however, i would like to show only 10 results per page, and then have a next button or link to show the next 10 results...

 

how can this be done? thanks...

Link to comment
https://forums.phpfreaks.com/topic/238923-how-can-i-limit-amount-of-mysql-results/
Share on other sites

If you're performing a search using LIKE, rather than just a usual select query with a static or no where clause, it might be worth it to just grab all results and flip through them with javascript.

 

Save performing a bunch of cpu-heavy queries.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.