[DanielCoe]

Hi,

I need to select every date in a given month for a report. How can I do this in MySQL?

Originally the report was selecting all data we have for certain days, but some days there maybe no data at all, so I want to display rows even though there is no data for that date and show it as a '0' or blank.

So I thought the best way to do it would be to select all the days in a month first then see if there is any data on that date, but I don't know how to select every day in a given month.

Any helpers?

Thanks

Daniel