Re[2]: [PHP] HTML in database
| From: | Richard Davey | Date: | Thu, 05 Jul 2007 00:34:29 +0000 |
| Subject: | Re[2]: [PHP] HTML in database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-258289@lists.php.net to get a copy of this message | ||
Hi Bruce,
Thursday, July 5, 2007, 1:26:01 AM, you wrote:
> Thanks. Sorry, I should have mentioned I'm using MS Sql Server and
> I don't see a mssql equivalent to that function.
MSSQL treats '' as an escaped ', not \' like MySQL does.
So you can't addslashes it. Perform your own ' to '' conversion.
Also check to see if you've got RUNTIME Magic Quotes on, because that
will auto-escape data (\'), which is pointless for MSSQL.
Cheers,
Rich
--
Zend Certified Engineer
http://www.corephp.co.uk
"Never trust a computer you can't throw out of a window"