Quote:
Originally Posted by Tent Pitcher
If you go this route prior to running the query, you will probably want to replace the space with a wildcard (%) instead to match an either/or situation. Regardless, you will still need to concatenate the database contact names for instances where the POSTed contact name contains no space.
|
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.
Quote:
Such as John Doe shows results but not Johndoe
Can I change this code below to show results for johndoe as well?
|
What I wrote will handle that.
I think ;p