>我写了以下查询
SELECT COUNT(userID) From statistics WHERE userID = ""
此查询显示对网站的未自动访问次数。
当我使用双引号时,该查询在phpmyAdmin中有效,但是当我使用如下所示的单引号时,它不起作用,它只是给了我存储在表中的记录数
$queryB = "SELECT COUNT(userID) From statistics WHERE userID = ''";
$resultB =mysql_query($queryA, $con) or die(mysql_error());
$authB = mysql_result($resultB, "COUNT(userID)");
echo "the number of authenticated visits were $authB<br />'n";
我不知道它为什么会破裂,有什么想法吗?
您将查询存储在$queryB
中,但使用$queryA
不确定它是否有效...它首先想到的是:当你使用转义的双引号时怎么样?
$queryB = "从统计信息中选择计数(用户 ID),其中用户 ID = ''"''"
试试这个:
$queryB = "SELECT COUNT(userID) AS total From statistics WHERE userID = ''";
$resultB =mysql_query($queryB, $con) or die(mysql_error());
$authB = mysql_fetch_assoc($resultB);
echo "the number of authenticated visits were ".$authB['total']."<br />'n";
userID 是否有默认值?如果默认值为 NULL,则将查询更改为
$queryB = "SELECT COUNT(userID) From statistics WHERE userID IS NULL";
你应该对你的代码做一些改变
$queryB = "SELECT COUNT(userID) From statistics WHERE userID = ''";
$resultB =mysql_query($queryB, $con) or die(mysql_error());
$authB = mysql_result($resultB, 0, 0);
echo "the number of authenticated visits were $authB<br />'n";