PROBLEM IN INSERTING TEXT WITH SINGLE QUOTE
| From: | Jennifer Arcino Demeterio | Date: | Sun, 22 Apr 2001 04:59:22 +0000 |
| Subject: | PROBLEM IN INSERTING TEXT WITH SINGLE QUOTE | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8776@lists.php.net to get a copy of this message | ||
Hello all,
I am having a problem in inserting text with apostrophe to mysql database.
When a user fills out a form field that includes an apostrophe <ex. Jen's >,
the verify screen shows it as <Jen\'s> and it
is then input into the database as <Jen\'s> - automatically adding
the backslash. The problem is that when the record is pulled out of the MySQL
database into my display script it also shows up as <Jen\'s> - with
the backslash - but I want viewers to see it as <Jen's> - without the
slash. Then, if I modify the record and don't take out the slash, it adds
an additional slash so I wind up with <Jen\\'s>.
Can someone help me with my problem?
Thanks in advance,
Jen