php/mysql grouping and counting

[cjkeane]

Hi everyone.

I need to display a list of departments and a total of occurrences of each department in mysql/php.

eg.

There are 3 Administration types.

There are 5 Government types.

etc.

there is no error when i run the code below, but nothing displays happens either. i'd appreciate anyone's help. Thanks.

 

<?php
$query = mysql_query("SELECT CompanyName, CompanyBranch, DateRecorded, DateClosed, Year(DateRecorded) AS Year, CaseOwner.UsersDepartment
FROM records LEFT JOIN CaseOwner ON CaseOwner = CaseOwner.ProperName
GROUP BY CompanyName, CompanyBranch, DateRecorded, DateClosed, CaseOwner.UsersDepartment
ORDER BY CaseOwner.UsersDepartment") or die("SELECT Error: ".mysql_error());
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(CaseOwner.UsersDepartment)'] ." ". $row['CaseOwner.UsersDepartment'] ." types.";
echo "<br />";
}
?>