Use the addslashes() call to automatically escape characters like that.
MySQL will not add the slashes into the table cell, so no need to
stripslashes() after you SELECT it back out.
-----Original Message-----
From: Mike Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Submiting Data with an '
Hello everyone,
I'm having a problem of submiting an ' into a mysql
database. When I have a ' it doesn't update or submit
the data. but if I use \' it works fine. Does anyone
know of a way around this.
Thanks
--Mike
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
PHP General 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]
--
PHP General 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]
