php mysql apostrophe issue
| From: | Matt Palermo | Date: | Sun, 04 May 2003 15:20:46 +0000 |
| Subject: | php mysql apostrophe issue | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-146355@lists.php.net to get a copy of this message | ||
I know that in order to insert an apostrophe into a mysql database,
instead of putting one apostrophe, you need to put double apostrophes.
So to do this, I am using the command:
$NewTitleBox=eregi_replace("'", "''", $TitleBox);
but instead of replacing the apostrophe with a double apostrophe, it
replaces it with this \''
anyone got any ideas? Thanks.
Matt