Re: MySQL Problem with PHP
| From: | David Robley | Date: | Wed, 26 Jun 2002 10:03:31 +0000 |
| Subject: | Re: MySQL Problem with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103926@lists.php.net to get a copy of this message | ||
In article <20020626093515.12275.qmail@pb1.pair.com>,
ben@themidwestgroup.com says...
> I am using PHP and MySQL on a 2k dev box to be uploaded to a linux box
>
> I have a piece of SQL
>
> INSERT INTO
contracts (key,
> content) VALUES (1,'blah blah blah
> character 39 is a single speach mark '+CHAR(39)+' blah blah blah')
>
> Instead of inserting: 'blah blah blah character 39 is a single speach mark '
> blah blah blah
> It inserts 0
> All variations work fine when there is no single speachies
>
> help?
Look into addslashes and the various magic_quotes settings in you r
php.ini.
--
David Robley
Temporary Kiwi!
Quod subigo farinam