The query below works just fine, but now I need to add two more COUNT(*)'s ... 31_EXPECTED='B' and 31_EXPECTED='C'. I can add the column to the results table, but it doesn't correctly count the 2nd and 3rd set of "expectations."
Can anyone give me a hint?
Laurie
$result = mysql_query("SELECT 31_EXPECTED, MONTH, COUNT(*) FROM Client001 where 31_EXPECTED='A' and SERVICE='Emergency' GROUP BY MONTH");
echo "<table border=1>\n";
echo "<tr><td>Month</td><td>Better Than Expected</tr>\n";
while ($myrow = mysql_fetch_row($result)) {
printf("<tr><td>%s</td><td>%s</td></tr>\n", $myrow[1], $myrow[2], $myrow[3]);
