cant get text into the DB

[adriann]

Hi,
Im having a lot of trouble with an INSERT into a DB, and I think its because the big hunk-o-text I want to insert contains the QUOTE characters.
This one --> " <-- (Ascii(22)).

I will be inseerting the body text of emails, so it's likely that this will occur often.
Could the occourence of these characters in the text I want to INSERT screw up the operation?
The other values have the quote symbol around them, so I assume that instances of quote chars in the text I want to insert are casuing the query to fail.

Is this correct logic?

If so, is there a way around this problem?

thx
Adrian

[ronverdonk]

Before inserting data into the db, you should use the PHP addslashes command. http://nl2.php.net/manual/en/function.addslashes.php

string addslashes ( string str )
Returns a string with backslashes before characters that need to be quoted in database queries etc. These characters are single quote ('), double quote ("), backslash (\) and NUL (the NULL byte).

When retrieving data from the db you then use the stripslashes command. http://nl2.php.net/manual/en/function.stripslashes.php

string stripslashes ( string str )
Returns a string with backslashes stripped off. (\' becomes ' and so on.) Double backslashes (\\) are made into a single backslash (\).

Alternately, you can use the mysql_real_escape_string command.
http://nl2.php.net/manual/en/functio...ape-string.php

See the PHP documentation for more details http://nl2.php.net/manual/en/index.php

Ronald :cool: