php mysql更新错误

Question

代码:

mysql_connect('localhost','root','root');
mysql_select_db('share_counter');  

$sql_insert = "UPDATE wpshare SET '$social_name'='45' where post_title = '$post_title' ";
mysql_query($sql_insert) or die(mysql_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 ''twitter_count'='45' where post_title = 'test'' at line 1

提前致谢

Answer 1

省略 $social_name 上的引号

$sql_insert = "UPDATE wpshare SET $social_name='45' where post_title = '$post_title' ";