Sending code in a query

[foofoobar]

I'm sending HTML in a query but am having problems. Plain text goes through but long amounts of text and code fail (more than likely due to escape chars). The query is an update to a TEXT field and I'm using stripslashes, addslashes and magic_quotes_gpc is enabled but for some reason it must be missing some escape characters.

Is there a list of escape characters and what stripslashes, addslashes and magic_quotes_gpc take care of? Because it seems like they are missing something.

[laserlight]

What DBMS are you using? Some may require '' instead of \' to escape single quotes.

Also, have you checked with singe/double quotes on smaller test data samples yet?

You dont need stripslashes() if magic_quotes_gpc is 1, so you probably only need to check for magic_quotes_gpc

[foofoobar]

Using MySQL, natch 😉

Yeah I found the problem and it was elsewhere in my code; had a type in my variable declaration. Works fine now.

Thanks for 6he help though.