Update Mysql database, php error

[crawlerbasher]

I'm trying to update my database but keep getting this error.

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Title' = 'Testing today', 'Story' = 'This' WHERE 'id' = ''' at line 1

 

I can't seem to find whats causing the problem.

 

This is the code.

 

				$id = $_POST['id'];
				$Story = $_POST['Story'];
				$Title = $_POST['Title'];

				mysql_query("UPDATE TaruNews SET 'Title' = '$Title', 'Story' = '$Story' WHERE 'id' = '$id'")or die(mysql_error());

[PFMaBiSmAd]

String data is enclosed in single-quotes, making them strings. Column names are not.

[-Karl-]

	
mysql_query("UPDATE TaruNews SET `Title` = '$Title', `Story` = '$Story' WHERE `id` = '$id'")or die(mysql_error());

[crawlerbasher]

I've tried that and get no error messages now.

 

But now its just not updating it.

I've checked it to make sure that the tables name are the same in the script and that the casing match too.

[-Karl-]

Echo the query, make sure all the information you expect to be there, is actually there. (id, Title, etc)

[crawlerbasher]

when I echo it, all I get is 1

[crawlerbasher]

ok got it working now, thank you.