single quote

I am trying to insert a string with single quote ie can't but mysql fails
to insert record how do I get round this.

Re: single quote

ntlnews wrote:

> I am trying to insert a string with single quote ie can't but mysql fails
> to insert record how do I get round this.

You must "escape" the single-quote like 'What\'s what'

mysql_escape_string() and mysql_real_escape_string()

http://dev.mysql.com/doc/refman/5.0/en/mysql-escape-string.h tml