Problem with update...

[swon]

Hi everybody,

I've updatet MySQL to version 3.23.49 and PHP to 4.3.0.
Now I get some errors if I make following Insert into MySql:

$anfrage = "INSERT INTO dbdata SET content = '$content' WHERE id='$id'";

works fine, but when the variable $content has following content:

$content = "<form onSubmit=\"return checking();window.open('test.php','fentster','width=300,height=300')\">";

...I get the error, MySql has a problem with the (') in the query

I do not understand why on before towards those the versions of PHP and MySQL marvelously functioned and now no more completely? There are any attitudes in php.ini or for instance in MySQL?
Any suggestions?

Any ideas would be very appreciated

[diego25]

http://www.php.net/manual/en/function.addslashes.php

Diego

[swon]

thanks a lot Diego, I saw there that magic_quotes_gpc must be 'On' for automatically escape the single quotes!
And this part in the php.ini file was set to 'Off';