PDA

View Full Version : php5/mysql finding/display records by 1st letter, then 2nd letter, etc


steve800
04-14-2009, 02:29 AM
I'm relatively newbie ... but... Is there any way to use a form to search a client table by entering the first letter of the client's last name to narrow the list, then enter the 2nd letter to narrow the search further, etc? with more than 4,000 client records it would be nice to look for "Baker, Thomas" by starting with a "B", then the "a", then the "k", and so on....

Any assistance would be greatly appreciated.

p.s. Posted on PHP forum and received recommendation to try AJAX forum....

TinyScript
04-14-2009, 03:03 AM
I'm relatively newbie ... but... Is there any way to use a form to search a client table by entering the first letter of the client's last name to narrow the list, then enter the 2nd letter to narrow the search further, etc? with more than 4,000 client records it would be nice to look for "Baker, Thomas" by starting with a "B", then the "a", then the "k", and so on....

Any assistance would be greatly appreciated.

p.s. Posted on PHP forum and received recommendation to try AJAX forum....

Googled
ajax searching with current string

http://www.w3schools.com/php/php_ajax_livesearch.asp