Insert statement

Anon

Hello everyone,

I am trying to insert some records into a database but I ran in to a problem using the following statement:

INSERT INTO finalMembership (memberID, salutation, fname, lname) VALUES('42', 'Mrs', 'Mary Patricia','O'Neill')

because the last name has ' in it, the statement gives me an error. Is there some way to temporarly strip the name of the ' or preferably to do something that would add O'Neill but not have the ' read? Maybe somehow make the value O'Neill = O\'Neill?

If I could do the O\'Neill thing would it put the \ into the database as well, cause I wouldn't want that...

Thanks for your time, any help is greatly appreciated.

foxden

I usually enclose the values behind a \" like this:

INSERT INTO finalMembership (memberID, salutation, fname, lname) VALUES(\"42\", \"Mrs\", \"Mary Patricia\", \"O'Neill\")

Josh

gargamel

I read an article on this forum or was it devshed where they preached the use of slashes in front of special characters. The point they were trying to make i guess was concerning a problem just like yours.
They suggested using the

addslashes (string str);

function that will encapsulate all ' " and NUL bits with escapeslashes and thus make your query work. I have not yet tested this myself, since I've had no reason to do so but I think it should do the trick.