Jump to content

Archived

This topic is now archived and is closed to further replies.

casbboy

MySql Error on Updating when 'this' quotation mark in variable

Recommended Posts

I have a php update like this:

[code=php:0]
$upsql = mysql_query("UPDATE comments SET comment2='$oldcomment', comment='$newcomment', edited='y', verified='$verified' WHERE user_id='$userid' AND edited='n' AND comment_id='$commentid'", $connection)
or die(mysql_error());
[/code]

The problem is that $oldcomment features a ton of text that has both "this" type of quotation marks and 'this' type of quotation marks. I get a mysql error because of these quotation marks when trying to update the database.

I have done a string replace to pull them out just for testing sake and the update works fine... so it is the existance of the quotation marks that are causing issues.

i NEED these quotation marks to remain, but how can I do the update query and avoid the error?

Thanks
Ryan

Share this post


Link to post
Share on other sites
You have to escape these quotes -- the DB wrapper can handle this, or PHP can handle this, or you can do it yourself.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.