mysql query

[phpprog]

Hi All
I want to execute the following query
INSERT INTO table_name (field_name) VALUES ('Jerry's practice focuses');

but its giving the error because of the apostrophe after Jerry.
Any help will be greatly appreciated.

tHANKS

[thom]

This should work:

$insertString = "Jerry's practice focuses";
$query = "INSERT INTO table_name (field_name) VALUES ('".addslashes($insertString)."');";

addslashes adds slashes to the string (well duh) so the addslashes($insertString) would return: "Jerry\'s practice focuses"

[phpprog]

Thanks very much. It worked