Retrieving search queries in pages
Posted: Wed Jun 06, 2007 12:44 pm
I'm writing a web page in php that searches a mysql database that contains some log information. I've got the sql queries working exactly how I want them. The issue I currently have is that as the database gets larger the data thats being returned is getting quite big and the searches are taking longer. What I would like to implement is returning the queries in pages (say 50 or 100 log entries on a page). At first I thought I would read the query into an array and display it in pages but thats not buying me a lot and I believe there has to be a better way. I would appreciate any suggestions or tips that would point me in the right direction on this.
Thanks
Thanks