为什么这个 MySQL 查询可以在 phpmyadmin 中工作，但在我的 php 脚本中不返回任何内容？

Question

我在 phpmyadmin 中尝试了以下查询，它返回了正确的结果，但是当我尝试将结果传递给 php 中的变量时，该变量基本上是空的（即，当我尝试在 while 循环中使用 mysql_fetch_array 时，我什么也得不到并且 mysql_num_rows 仅返回 1)。

这是否与我在 MySQL 中创建临时表有关？这是查询：

CREATE TEMPORARY TABLE solved
SELECT comments.nid FROM flag_content
LEFT JOIN comments ON flag_content.content_id=comments.cid
LEFT JOIN term_node ON term_node.nid=comments.nid
WHERE flag_content.fid=3 AND term_node.tid=522;

SELECT node.nid, node.title, users.name, node_counter.totalcount, node_comment_statistics.comment_count, node_comment_statistics.last_comment_timestamp
FROM node
LEFT JOIN term_node ON node.nid = term_node.nid
LEFT JOIN node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN node_counter ON node.nid = node_counter.nid
LEFT JOIN users ON node.uid = users.uid
LEFT JOIN solved ON node.nid=solved.nid
WHERE term_node.tid=522 AND solved.nid IS NULL;

我将此查询存储在 PHP 函数中：

function getPosts(){
   dbConnect(); //establishes connection
   //"....." in the following line is the above query
   return mysql_query(".......") or die("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $query . "<br />\nError: (" . mysql_errno() . ") " . mysql_error()); 
}

调用它的代码行是：

$result = getPosts();

当我调用 getPosts() 时，查询因致命错误而终止。我收到同一错误的两个版本，具体取决于查询是否使用“.”跨多行连接。或者简单地写在一行上。

跨多行连接时出错：

Error: (1064) 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 'comments.nid FROM flag_content LEFT JOIN comments ON flag_content.content_id=com' at line 1

在单行上写入时出错：

Error: (1064) 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 'SELECT node.nid, node.title, users.name, node_counter.totalcount, node_comment_s' at line 1

Answer 1

尝试一次执行一个查询。创建临时表，选择其中，然后将其作为三个单独的查询删除。作为一项安全预防措施，sql 套接字只允许在执行块中执行一个查询，

它看起来像......

mysql_query("CREATE TEMPORARY TABLE solved
SELECT comments.nid FROM flag_content
LEFT JOIN comments ON flag_content.content_id=comments.cid
LEFT JOIN term_node ON term_node.nid=comments.nid
WHERE flag_content.fid=3 AND term_node.tid=522;");


 $结果= mysql_query（“选择node.nid，node.title，users.name，node_counter.totalcount，node_comment_statistics.comment_count，node_comment_statistics.last_comment_timestamp
从节点
LEFT JOIN term_node ON node.nid = term_node.nid
LEFT JOIN node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN node_counter ON node.nid = node_counter.nid
左连接用户在node.uid = users.uid
LEFT JOIN 已解决 ON node.nid=solved.nid
WHERE term_node.tid=522 ANDsolved.nid 为 NULL；
”）；