Basically what I want to do is to be able to select all ofthe dates between 2 dates.
So say that I have 1 record each on March 23, March 24, March 25
but I select dates between March 1 -March 25
I would like to get 25 results back, naturally there would be empty results on dates with no information.. So in my case above I would have 22 empty results and only 3 results with data in them. All results would have their date on them however.
Does this make anysense?
An idea I have tossed around:
Using PHP to create a temporary table of dates, and joining that table on my query.
I figured it migh tbe possible to have mysql select all the dates though.. so I was holding off that doing the above solution.