PHP updating mysql issue

[JamesM]

If I am using the following php to update the table:-

$q = "UPDATE results SET hello = '$_POST[hello]' WHERE id = '1'";

and if $_POST[hello] equals:-

hello i'm a cool dude

it would create an error as follows:-

$q = "UPDATE results SET hello = 'hello i'm a cool dude' WHERE id = '1'";

You can see there are too many ' in that query, how would I go about making the query work even if the ' is still there?

 

[JamesM]

fantastic, just what I was looking for!