Fill in missing date if no record on particular date

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

little_girl
Forum Newbie
Posts: 20
Joined: Tue Oct 13, 2009 5:11 am

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

Post 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.
Post Reply