[RESOLVED] multiple COUNTs in a query on same field

[rbragg]

Why would only the 2nd COUNT line be successfully counting?


$queryCount = "
SELECT
COUNT(call_num) AS callCount,
COUNT(CASE WHEN status_num = '1' THEN status_num END) AS closedCount,
COUNT(CASE WHEN status_num = '2' THEN status_num END) AS openCount,
COUNT(CASE WHEN status_num = '3' THEN status_num END) AS forwardCount,
COUNT(CASE WHEN status_num = '4' THEN status_num END) AS followupCount,
COUNT(CASE WHEN status_num = '5' THEN status_num END) AS progressCount
FROM vigil_call
GROUP BY status_num
";
$countResults = mysql_query($queryCount) or die( "Count query failed: " . mysql_error() );
$count = mysql_fetch_assoc($countResults);

[rbragg]

Ah! I took out the GROUP BY clause and it works perfectly!