character ' pass to MYSQL db

[Anon]

Everytime when I pass a string with character ' in MYSQL query. My code crash.
I know MYSQL query use special character ' as a delimiter. Is there any function which can scan and take out character ' in the input string or text first before I pass it in my query?

Thanks in advance.

Tom

[Anon]

check out:
strip_slashes()
and
do a ereg_replace("'","''", $input);

Both those usually help when putting unknown text into a db. hope that helps.