Fckeditor and mysql

PHP
1

Hi everybody,
I am using fckeditor to insert text in mysql… But i am having one problem. That is when try to insert text like “i’ve the”, the error messages “You have an error in your SQL syntax, check the manual that corresponds to your MySQl server version for the right syntax to use near 've the” occurs.

By the by i am using web server as given below:
* Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9
* MySQL client version: 5.0.51a
* PHP extension: mysql
Please anyone help me to get out of this problem.
Thanks in advance.

2

Hi cranial-bore,
Thanks for your help. With your suggestion I solved my problem.
Thanks for your help once again.

3

This hasn’t got anything to do with fckeditor (which has become ckeditor by the way) it’s just basic escaping your data before you use it in a query.

Use [fphp]mysql_real_escape_string[/fphp] on your POST vars before sending them to MySQL. You’d have exactly the same problem with a normal text area.