[SOLVED] Apostrophe SQL Problems

[CloudSex13]

I'm having problems updating data from a database with apostrophes in it.

 

My SQL statement is as follows:

 

$text = "They're here.";

mysql_query("UPDATE Table SET Field='$text'");

 

Any workaround for this? Thanks!

[Hybride]

You have to escape your apostrophe in $test.

$text = "They\'re here.";

or mod how you put the $text in the query:

mysql_query("UPDATE Table SET Field='" . $text . "'");