table update question

[dreams4000]

Hi all,

I have a table with some names in it along with some other data. Some of the names contain ' Everything updates fine except the rows with the ' in their name. I am using the column that has the names as the unique identifer as that is just how it has to be for this particular setup.. but the question is, how can I get those to update? The data is being dumped from some other system so I dont have any control as to how it is coming in. I know the ' in the names are causing the mysql call to have problems but not sure how to work around that. any ideas?

example that isnt working:

$tmpquery = "UPDATE sometable SET some_field = '$my_var 'WHERE messed_name = 'some'messedup'name' ";

[devinemke]

[man]addslashes[/man]

[dreams4000]

Tried that.. doesn't seem to do anything.

$some_name = addslashes($some_messedup_name);

$tmpquery = "UPDATE sometable SET some_field = '$my_var' WHERE messed_name = '$some_name' ";

messed_name and $some_messedup_name both have ' in them..