I want a for which will have a textbox, when you hit submit it lists all the username's from inside my DB with feild name username...
So if i entered JackJ it would list everything close such as..
Jacks Jack1 JackJ Jackson
how can i do this??
What if I entered "Jackson"? Should it match all those same values?
well if there is no 100% match it shows the closest matches...
to get results that 'sound like' an input, you could use the SOUNDEX functionality which is available in mysql.
Here a soundex tester... you could search for values who have a SOUNDEX value of at least 3.
-Brian
