RE: [PHP] strange double quotes From: Maxim Maletsky (maxim.maletsky <email protected>)
Date: 11/15/00

 with a ';' you just terminated the SQL statement.

use this:

UPDATE table SET field='&quot;';

notice single quotes around ? by them we say that SQL has to ignore
everything inside the string (only a ' has to be escaped)

hope it helps.

-----Original Message-----
From: Adrian Murphy [mailto:adrian.murphy <email protected>]
Sent: Wednesday, November 15, 2000 10:59 PM
To: php-general <email protected>
Subject: [PHP] strange double quotes

when i do an insert on a mysql db,the damn thing refuses to take a double
quote.it will take everthing b4 the quote but not the quote itself or
anything after it.
i use addslashes.is mysql a bit tempremental about double quotes or what?
an ereg_replace don't seem to be working either.e.g
$pat = '"';
   $rep = '&quot;';
$content = ereg_replace($pat,$rep,$content);
this whole thing seems strange to me as addslashes has worked b4. 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>