Re: [PHP] Search Suggestions

2008-08-31 Thread Jochem Maas
Dan Shirah schreef: Hello, I'm hoping to get a few good ideas on the best way to perform a search of PHP results. Currently I have a page that returns a list of collapsed customer data: Example + John Smith + Jane Doe + Robert Jones + Dale Bennett If the user clicks on a customer name it

Re: [PHP] Search Suggestions

2008-08-27 Thread tedd
At 9:31 AM -0400 8/26/08, Dan Shirah wrote: Any ideas? Dan: Yes, a few of them. 1. Use LIMIT in your MySQL query to get the number of records provided down to a manageable size. 2. Use pagination to keep the page size to a manageable size. Here's an example:

RE: [PHP] Search Suggestions

2008-08-26 Thread Simcha Younger
You could have (and I assume you already have) an id for each customer_name-DIV . This id should correspond to the customer id in your DB. You can then send out an AJAX request with the search term and have it return a list of the ids of the customer-DIV's to expand. A similar solution is to send