I'm having an issue with my MySQL query/php, I try to update a row in my database that will work usually, but when the string has a '
in it, for example
I don
'
t like green eggs and ham.
The '
in it will cancel the whole response out and not update the row, so if I put something like this without the '
for example:
I dont like green eggs and ham.
The string will save to the row. Below is the MySQL query used and where I get the string from.
$NewMessage = $_POST['message123'];
mysql_query("UPDATE Account SET `function` = 'Message', `note` = '$NewMessage' WHERE `id` = '$ID' AND `Online` = '1'");
If you need anymore source or anything, please let me know, let me know what you think, thanks!
No comments:
Post a Comment