php - 提供的参数不是有效的 MySQL

Question

$qs = 'SELECT cnam,COUNT(*) as cnt FROM cdr WHERE '.$where.' GROUP BY COUNT(*)';
$objRs = mysql_query($qs);
while($obj = mysql_fetch_array($objRs))
{
    if ($obj['cnam'])
    {
        $names[$obj['cnam']]['call_name'] += $obj['cnt'];
    }
}

foreach($names as $h=>$count)
{
    if ($h)
    {
        echo '<operator name="'.$h.'" '.($count['call_name'] ? 'callcenter="'.$count['call_name'].'"' : "").'></operator>';
    }
}
echo '</operators>';

我做错了什么？它说问题就在这里:

mysql_fetch_array(): supplied argument is not a valid MySQL

while($obj = mysql_fetch_array($objRs))

不知道我的错误在哪里。

Answer 1

您不能group by 聚合函数。我想你打算:

SELECT cnam, COUNT(*) as cnt
FROM cdr
WHERE '.$where.'
GROUP BY cnam;