TalkPHP - View Single Post - Funny Parse -> MySQL Insert error

Wildhoney · 06-05-2009, 11:59 AM

I see another problem that will prevent it from being entered into the database correctly. It concerns the content of the first entry (It's the only one I checked): "...it's place in business..."

If the body contains an apostrophe then it will break. You need to escape those characters:

php Code:

$content = mysql_real_escape_string($element->content);

You need to do the same for title, also. If you add the or die to your mysql_query function then you will see any further errors:

php Code:

mysql_query($szSQL) or die(mysql_error());

06-05-2009, 11:59 AM	#7 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	I see another problem that will prevent it from being entered into the database correctly. It concerns the content of the first entry (It's the only one I checked): "...it's place in business..." If the body contains an apostrophe then it will break. You need to escape those characters: php Code: $content = mysql_real_escape_string($element->content); You need to do the same for title, also. If you add the `or die` to your `mysql_query` function then you will see any further errors: php Code: mysql_query($szSQL) or die(mysql_error()); __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.