MySQL syntax question

[examancer]

Seems like a simple question, but i'm having trouble finding the answer:

When using quotes ("") or apostraphes (sp?) ('') to incapsulate data inserted into a MySQL database, what do you do when you come across a quote or apostraphe in your data?

say you are doing:

$sql = "INSERT INTO posts SET title = 'Hi!', post = 'I don't think we've met before';
$q = mysql_query($sql);

what do you replace that apostraphe with? \'?

[Anon]

Exactly - \'. The PHP function addslashes() adds \ to any character that needs to be escaped.