Use addslashes() when inserting/updating the DB
use stripslashes() when extracting.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
----- Original Message -----
From: "Jorge Giménez Mayorgas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 7:48 PM
Subject: [PHP-DB] Special character on an INSERT statement
Hi .
I'm trying to do this on an INSERT statement.
$sql= "INSERT .... (' TONS OF CD'S ')
or any phrase with the character ' .
Obviously it gives an error when execeting mysql_query.
How can I do it ?
Thanks,
Jorge Giménez
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]