Re: php/mysql search. need help

There are various "sounds like" modules such as soundex and metaphone and suchlike. These can ameliorate bad spelling. Another option, if you have a limited number of types available, is to give the user a popup menu rather than free-form box to type in. In general, the fewer ways you can provide for the user to type incorrectly, the better. -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm ----- Original Message ----- From: Lizlynch <lizlynch50@hotmail.com> Newsgroups: php.general To: <php-general@lists.php.net> Sent: Friday, September 07, 2001 6:59 PM Subject: php/mysql search. need help i have a form where a user inputs a home service type and this results in a list of that value, eg a user inputs 'plumber' and a list of plumbers is displayed. if a user accidentally types plumbar no results are displayed. is there anyway of making php/mysql recognise the first three letters or give a closest match to the query. yours liz lynch