Hi,
Hoping to get help with a small but annoying problem. I have a MySQL database holding both first and last names in a name field.
Ex: Horn Nina
Most of the time I simply echo out the full names from the db. However, for one special purpose I echo out the lastname and the initial of the first name. (This is done with {$name[0]} . $name[1] {0})
Ex: Horn N
Now, as it turnes out, one of the users in my db has two surnames!
Ex. Van Horn Nina, (which echoes out Van H)
The only way to get the output correct is to combine the two surnames with a hyphen, underscore or other character.
Ex: Van_Horn N
The user is not pleased! She writes her name with a space between the two names!
Is there a way I can include a non-printable sign in the db (some ASCII-sign) which the php script will interpret as a sign ?
If so, what (ASCII-sign) do I include and how do I write it into the db?
Thanks!
