MySQL Problem with PHP
| From: | BB | Date: | Wed, 26 Jun 2002 09:34:37 +0000 |
| Subject: | MySQL Problem with PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-103925@lists.php.net to get a copy of this message | ||
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?