dealing with escape characters and mysql

[jackvull]

Hi
I am trying to put the following text into my DB but mySQL keeps rejecting it as the character is invalid.
The character is ;
which has obvious problems.
I have tried escaping it with \; but doesn't work either.
Any ideas?

It's for putting things i a databse like HTML chars such as   or Å

Thanks

[tomda]

Use htmlentities() or htmlspecialchars() before inserting data in the database. Do some search for those two functions to get some basic example on how it works.
It is a MUST to check your data and replace special string before insertion in Mysql.

[jackvull]

but won't htmlentities just replace special characters with the html equivalent e.g. & to "

The problem I have is that MySQl sees the ; and thinks that it has come to the end of the statement even though I want to actually insert the ; into the database

[tomda]

Indeed, it does! And ; is not a special character. Never realised because I never had problems with ; character.

I just tried it now and no error... All fine!

Can you post your query so that we have a look at it.

[henry0]

Easy integration through a concat
ex:
$start="aa";
$end=";";

$total=$start.$end;

result:

echo"$total";

will read
aa;

[jc_armor]

try using addslashes :)

[jatar_k]

if your mysql is interpretting ; as end of line then you probably have a quote mismatch somewhere.