Return zero instead of nothing

[Jared Valarta]

I hope this isnt a stupid question, Ive searched high and low and the answer doesnt seem obvious.

I want this query to return a zero on the days of selection that have no record.

SELECT thedate, thecount FROM thetable WHERE DATE_SUB('$Today',INTERVAL 6 DAY) <= thedate AND thedate <= '$Today' && ID = $ID ORDER BY thedate ASC

So it works great if all the days in the selection have a value. If one of the days in the sequence has no record, then it skips it, and thus no value is presented.

The question is, how do I get mysql to give me a zero if it doesnt find anything?