There are various "sounds like" modules such as soundex and metaphone and
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
Wanna help me out?  Like Music?  Buy a CD:
Volunteer a little time:
----- Original Message -----
From: Lizlynch <[EMAIL PROTECTED]>
Newsgroups: php.general
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
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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to