Backslash not escaping apostrophe?

[b3t3l]

not sure what's happening but i keep receiving the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Alba,12192 Vilafames,12183 Vilanova D'Alcolea,12162 Vilar De Canes,12124 Villahe' at line 1

which relates to this:

'12194 Vall D\'Alba', '12192 Vilafames', '12183 Vilanova D\'Alcolea', '12162 Vilar De Canes', '12124 Villahermosa Del Rio', '12500 Vinaros', '12135 Vistabella Del Maestrazgo');

if i remove the backslash and apostrophe before Alba and Alcolea then there is no error. so it appears (to this newbie) that the backslash is not escaping the apostrophe?

if anyone has any ideas it would be appreciated

[guelphdad]

are you entering that directly into the mysql client or through some front end application? It inserts fine using the client.

[b3t3l]

yes, i inserted the locations directly into mysql using backslash to escape the apostrophe. then i have a front end php site using javascript to input the locations - it's here i'm using backslash again to escape the apostrophe and receive the error

[guelphdad]

use mysql_real_escape_string in your php application.