MySQL query with apostrophes/quote marks..

[khanahk]

Greetings,

 

I am trying to reconcile the following reality:

 

$query = "INSERT INTO mytable VALUES('', 'A user's input. It contains one or more apostrophes or quote marks.')"; 

 

This, clearly, is a problem and I don't know how to reconcile it.

 

This forum clearly has reconciled it. Consider my apostrophes and quote marks: ''' "" "' ' '"!!

 

Thanks!

[khanahk]

Found the fix:

 

$myvalue = mysql_real_escape_string(A user's input. It contains one or more apostrophes or quote marks.);
$query = "INSERT INTO mytable VALUES('', '$myvalue')";