Encryption Woes

[Saeven]

Hello,

I'm encrypting data before the storage, and sometimes the encryption causes that the encrypted string contains the single or double quote character.

This causes trouble when the mysql query is formulated to store the data since it escapes the string prematurely and throws syntax errors as a result. Is there a form of mySQL query where I can store data without needing to include it in quotations of sorts? Both in update and insert operations.

Thanks!

[kevinsequeira]

before u use them in the query enclose it in addslashes()

http://ca.php.net/manual/en/function.addslashes.php

reg
kevin