您的SQL语法有错误;查看与您的MySQL服务器版本相对应的手册,了解在')'


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 ')'

Drupal-6日志条目中收到错误

您的SQL语法有错误;查看与MySQL服务器版本相对应的手册,以获得在第14行查询")"附近使用的正确语法:SELECT node.nid AS nid、node.title AS node_title、node.uid AS node_uid、node.type AS node_type、node_revisions.format AS node_revisions_format、node_data_field_link_of_deal.field_link_of_dial_url AS node_data_field_link_of_deal_url,node_data_field_link_of_deal.field_link_of_dale_title AS node_data_field_link_of_deal_field_link_of_dale_title、node_data_filield_link_fof_deal_attributes AS node_data _field_ink_of_deel_field_liink_of_deal_attributes,node.vid AS node_vid FROM node node INNER JOIN term_node term_node ON node.vid=term_node.vid LEFT JOIN node_revisions node_revisions.vid LEFT JOING content_type_popular_deal node_data_field_link_of_deal ON node.vid=node_data_field_link_of_deal.vid WHERE(node.type in('opular_deal'))AND(term_node.tid=)in/home/watzupdeal/www/customid_block/tag_cloud.php ON第20行。

tag_cloud.php中的我的代码

<?php
$city_id = $_COOKIE['city_id'];
$sql="  SELECT node.nid AS nid,
node.title AS node_title,
node.uid AS node_uid,
node.type AS node_type,
node_revisions.format AS node_revisions_format,
node_data_field_link_of_deal.field_link_of_deal_url AS        
node_data_field_link_of_deal_field_link_of_deal_url,
node_data_field_link_of_deal.field_link_of_deal_title AS      
node_data_field_link_of_deal_field_link_of_deal_title,
node_data_field_link_of_deal.field_link_of_deal_attributes AS     
node_data_field_link_of_deal_field_link_of_deal_attributes,
node.vid AS node_vid
FROM node node 
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
LEFT JOIN content_type_popular_deal node_data_field_link_of_deal ON node.vid =     node_data_field_link_of_deal.vid
WHERE (node.type in ('popular_deal')) AND (term_node.tid = $city_id)
";
$result = db_query($sql);
?>

您的变量$city_id为null或空字符串

... (term_node.tid = $city_id) ...

在错误消息上变为:

... (term_node.tid = ) ...

这使它成为sql语法错误。您应该将其更改为:

... (term_node.tid = '{$city_id}') ...