PROBLEM IN INSERTING TEXT WITH SINGLE QUOTE

From: 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

« previous php.db (#8776) next »