CodingForums.com - View Single Post - php5/mysql finding/display records by 1st letter, then 2nd letter, etc

steve800 · 04-14-2009, 01: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....

04-14-2009, 01:29 AM	PM User \| #1
steve800 New to the CF scene Join Date: Apr 2009 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts	php5/mysql finding/display records by 1st letter, then 2nd letter, etc 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....