wanted to get all dates in mysql result
- by PankajK
I have mysql table called user(id, name, join_on) join on is a date field what I want is to show in each day how many uses has been created I can use group by but it will only give me the dates when users get added like if
date
4/12/10 5 users added
4/13/10 2 users added
4/15/10 7 users added
here date 4/14/10 is missing and I want listing of all dates in one month.
I have one solution for it by creating another table only for adding date and that table will left join my users table on join_on and will give total result but I don't want to do that as for creating that I need to create and add entries in date table please suggest the different approach for doing so.
Thank you.
