php - 运行 MySQL 查询时出错，寻找正确的语法

Question

运行 .php 文件时出现以下错误:

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 ''feeds_list' SET 'cron' = now() WHERE 'feed_id' = '1'' at line 1

代码如下:

$sql = mysql_query("UPDATE 'feeds_list' SET 'cron' = now() WHERE 'feed_id' = '$feed_id'") or die (mysql_error());

谢谢你帮助我

Answer 1

去掉表名和列名周围的''，应该是:

UPDATE feeds_list SET cron = now() WHERE feed_id = '$feed_id'

或使用反引号 (``)。