Mysql insert existing column to new tabl

[razmon]

Hi
I have a table that contains names with apostrophies. My code needs to transfer this column to another column in another table but I get an error my syntax is

$query="insert into allresorts (resortname, rating, points) values ('$row[resort]', '$rat', '$row[max_points]')";

in $row[resort] which comes from a different table there are names that contain an apostrophe (') and Mysql returns a fatal error. Can anyone please suggest a way around this.
Thanks and Regards
Ray

[Anon]

$query=sprintf("insert into allresorts (resortname, rating, points) values ('%s', '$rat', '$row[max_points]')", addslashes($row[resort]));