[SOLVED] apostrophe problems

[Gnub]

When ever i try to insert a record, and one of the fields contains a apostrophe, ( ' ), it throws an error at me.

 

So for example, if i try to insert a name called " O'Brian " , it wont accept it.

 

Is there anything i can do, either on PHP or on the MySQL database to solve this small issue?  changing of character sets? or something?

 

Thanks in advance.

 

Gnub.

[Broniukas]

" O\'Brian " 

[Gnub]

cheers

[Dragen]

what error do you get?

 

you could try using addslashes.

<?php
$variable = "O'brien";
$variable = addslashes($variable);
?>

[Gnub]

basically, what i've done is used a str_replace, to add the slashes.

 

I could use the add slash, see which one im happy using.

 

Error was basically, you have an error in your sql query, no specific info, but i discovered it was with the apos.

[Dragen]

addslashes would be better the str_replace as that's what's it's for

[Gnub]

yeah, just found out the long way.  Thanks.