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 [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
Newsgroups: php.general
To: <[EMAIL PROTECTED]>
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
