Quote:
Originally Posted by sarettah
I am not sure what you are trying to say there.
What I did will match names if they are like what was entered or if they are like what was entered with spaces removed, simple as that.
No need to manipulate the database any further to get at what the OP requested.
What I wrote will handle that.
I think ;p
|
If the database record for the name is "John Doe", and someone enters "JohnDoe" then a LIKE will not match them. What you did would work if the incoming POST request is for "John Doe" and the database record is either "JohnDoe" or "John Doe", but not if the request is for "JohnDoe" and the database record is "John Doe". So there is nothing wrong with what you said - it will absolutely solve half of the problem. The other half is doing basically exactly what you did on the scripting side, only on the database - which is where I suggested the temp table approach. Although I stand by my disclaimer that there are much better and more efficient ways to do it (the temp table solution that is).
Hope that answers your question.