Escaping SQL strings

[Anon]

I am having a problem with my sql code, primarily that I cannot insert certain data into my fields. If I were to try and insert the following string "China marker & coffee wash" mysql has problems with it. I believe that it has to do with the ampersand, but I don't know exactly how to resolve this issue. Is the ampersand a special sql character, and if so, how can I escape it. I tried mysql_escape_string but it hasn't gotten me anywhere. Any help will be very appreciated. Thanks

Ryan

[Anon]

Ryan

php has a function to allow you to automaticaly escape characters like "&". its called addslashes

so the syntax = addslashes($var). The other way to get this automatically to be done is to switch on magic quotes in the php.ini file

HTH

Gary Mailer