Code: Select all
<?php>
query="SELECT DATE_FORMAT(DateRecorded, '%Y-%m') as Month, COUNT(DATE_FORMAT(DateRecorded, '%Y-%m')) AS Count, ROUND( 100 * COUNT(DATE_FORMAT(DateRecorded, '%Y-%m')) / Count2, 2 ) AS Percentage,
(CURDATE( ) - DateRecorded) AS AgeInDays, (DateClosed - DateRecorded) AS ResTime,
sum(IF(Status='Closed',1,0)) As Resolved ,sum(if(Status='Open',1,0)) As Unresolved ,
sum(if(Status='Pending',1,0)) As Pending
FROM records, (
SELECT COUNT(DATE_FORMAT(DateRecorded, '%Y-%m')) AS Count2
FROM records
) AS c
GROUP BY Count2 ASC
WITH ROLLUP";
?>
2011-05
2011-04
2011-03
etc
any ideas on how to accomplish this?