Page 2 of 2

Re: Fill in missing date if no record on particular date

Posted: Thu Oct 22, 2009 4:55 am
by little_girl
I have sumping out the query as below:

SELECT DATE(DateJoined) AS jDate,
SUM(IF(CategoryID=1,1,0)) AS Cat1,
SUM(IF(CategoryID=2,1,0)) AS Cat2,
SUM(IF(CategoryID=3,1,0)) AS Cat3,
IF(CategoryID=NULL,0,COUNT(CategoryID)) AS Total
FROM Magazine
WHERE YEAR(DateJoined)=YEAR(CURDATE()) AND MONTH(DateJoined)=5 AND MagzineID=1
GROUP BY DATE(DateJoined)

This part is working fine.