insert statement

[vocoder]

i'm inserting some data into a mysql table using php....however it keeps failing because of special characters....

INSERT INTO entry_country (year, seq, type, cont) VALUES ('1970', '1237', '', 'Cote d'Ivoire', Africa)

as an example...it will fail because of the ' in D'Ivoire. how do i fix this?

[Wien]

you need to protect the quotes inside your strings with a backslash

INSERT INTO entry_country (year, seq, type, cont) VALUES ('1970', '1237', '', 'Cote d\'Ivoire', Africa)

if you insert statement is inside a php script use this function addslashes