[SOLVED] multiple selects counting in a query

[rbragg]

What do I get a syntax error with this query:

 

<?php
$queryCountAll = "
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 call
";  

$countAllResults = mysql_query($queryCountAll) or die( "Count query failed: " . mysql_error() );
$countAll = mysql_fetch_assoc($countAllResults);
?>

 

Thank you in advance!

[rbragg]

Ah, the syntax error goes away when I removed the comma after progressCount. DuH! I will keep from closing this topic for right now until I make sure the query is giving me the right counts.

[rbragg]

Ok, only the 2nd count line successfully counted.  ???

[rbragg]

Ah! I had an extra GROUP BY clause in there. When I omitted it, things work great.

[Orio]

You sure like talking to yourself...

 

Orio.

[rbragg]

Isn't that a good thing? I talked out a solution and shared it for those who may be searching about the same problem. Thanks for helping.