为什么这个“计数”功能不起作用?(PHP/MYSQL） - Why does this "count" function not work? (PHP/MYSQL)

Why does this "count" function not work? (PHP/MYSQL)

我有一个 php/mysql 脚本不起作用！我需要找出字符串确实存在多少行，并且我必须从"布尔全文"函数中计数。

这是不起作用的代码：

$resuslt=mysql_query("SELECT COUNT(homeid) 
                       FROM notes 
                       WHERE MATCH(title, text, tags) AGAINST('+$searchstring*' IN BOOLEAN MODE) AS accurate 
                       FROM notes 
                       WHERE MATCH(title, text, tags) AGAINST ('+$searchstring*' IN BOOLEAN MODE)");

我该怎么办？

这能做到你想要的吗？

SELECT COUNT(homeid) 
FROM notes 
WHERE MATCH(title, text, tags) AGAINST('+$searchstring*' IN BOOLEAN MODE) > 0;

如果homeid可以重复，您可能真的想要count(distinct homeid)。

这应该是一个子选择吗？如果没有，您有两个发件人：

"SELECT COUNT(homeid) 
                       FROM notes 
                       WHERE MATCH(title, text, tags) AGAINST('+$searchstring*' IN BOOLEAN MODE) AS accurate 
                       FROM notes 
                       WHERE MATCH(title, text, tags) AGAINST ('+$searchstring*' IN BOOLEAN MODE)");

你可以试试这个：

SELECT (SELECT COUNT(homeid) 
                           FROM notes 
                           WHERE MATCH(title, text, tags) AGAINST('+$searchstring*' IN BOOLEAN MODE)) AS accurate
                           FROM notes 
                           WHERE MATCH(title, text, tags) AGAINST ('+$searchstring*' IN BOOLEAN MODE)