[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] PHP and single quotes



> I am using a local linux server, and a win2k server in the office, both
with
> MySQL 3.23.37 and PHP 4.0.4, and if I add a block of text to the database
> with a single quote, ie "paul's nice email message." all works fine.

You must escape it. Send this instead:

"paul\'s nice email message."

The \ before the ' tells MySQL to take ' literally.