Hello everyone.
I am TOTALLY baffled. PLEASE, I need some help here.
In the event that one must deal with a name including an apostrophe...I am
looking for an appropriate solution.
The flow of data is that the name is entered in via a form text box, stored
in a MySQL table and then read back into another form or echoed out as
needed.
The problem that I am trying to overcome is what happens when an apostrophe
is used in a name, i.e. D'linda.
When I pull the information from the table and try to insert into a text box
on a form, I only get D. No 'linda.
I have tried escaping it, i.e. D\'linda and tried all the variations of ',"
and '".???."' that I can think of. The challenge is placing the name in
this text box:
<input type=text name=addr size=30 maxlength=30 value='".$row[addr]."'>
In the above code, D'linda is stored in $row[addr].
ALL input is most certainly appreciated!
- Steven