Return results for all days in range 1

[Horrid]

I am trying to get the count of all entries per day for 14 days. Days where there are 0 results I want to return as 0. My current SQL that gets the data I need but only for the days with data:

select COUNT(ID), DATE_FORMAT( madeTime, '%Y%m%d') from test where topicID=X group by DATE_FORMAT( madeTime,'%Y%m%d') LIMIT 14;

I want to avoid a combined php/mysql solution and just have mysql give me all days. Any hints?

Thanks

 

[IanWaterman]

Since your table test does not have data for the days with no activity you can not report on them.

YOu will need to create another table with all possible dates and the join this new table with your test table with a left outer.

Ian

 

[Horrid]

Thanks. I thought as much. I just used php to pad the missing days.