consecutive days resultset from db

[eluser]Colin Williams[/eluser]
One query will suffice. Nothing looks wrong with your result. You just need to loop through the dates, not the result set. So, for each day, loop through result and show results for the current day, or show an "empty" message for days without records.

That might be what w3bm was saying, but it sounded like he was saying to run a query for each date, which would be overkill.