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.
Fill in missing date if no record on particular date
Moderator: General Moderators
-
little_girl
- Forum Newbie
- Posts: 20
- Joined: Tue Oct 13, 2009 5:11 am