RE: [PHP] strange double quotes

with a ';' you just terminated the SQL statement. use this: UPDATE table SET field='"'; 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@eudos.com] Sent: Wednesday, November 15, 2000 10:59 PM To: php-general@lists.php.net 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 = '"'; $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@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net