weird mySQL error

[foid025]

Hi there. I have a problem with entering data into a mySQL db. Here is the error I get:

Query failed: 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 'd share with everyone our a little glimpse of our life here in Delhi. It's def' at line 1

The entry is an array of blog entries, seperated by two semi-colons (;😉. From the error, it seems that mySQL does not like the ' in the entry. This is a bit odd though. Any idea what I can do? Thanks a lot!

[thorpe]

[man]addslashes[/man].

[Installer]

Or like this (from the PHP manual):

// Formulate Query
// This is the best way to perform a SQL query
// For more examples, see mysql_real_escape_string()
$query = sprintf("SELECT firstname, lastname, address, age 
        FROM friends WHERE firstname='%s' AND lastname='%s'",
   mysql_real_escape_string($firstname),
   mysql_real_escape_string($lastname));

mysql_query()