MySQL Insert (';)

[Imrie]

Hello,

How do i insert the following characters into a MySQL database -

';

Here is my current code -

$sql2 = "INSERT INTO `data` (`content`) VALUES ('".$content."')";
mysql_query($sql2) OR die(mysql_error());

$content is the content inside a textarea, when i type '; and try and insert it it gives this error -

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 ';
')' at line 1

How can I do this?

Thanks,

[leatherback]

you need to always make sure you prepare variables for database interaction

try: $content = mysql_real_escape_string($content);

and then your insert