Counter scorecard based on date


I have mysql db connected and queried. The database is filled with entries several times a week but not daily. I’m trying to figure out how to show daily entries in counter if they have been submitted that day? Meaning that if there was a submission, counter will show the counted totals from the appropriate column and if there haven’t been any, counter will show 0. In other words I want counter to update daily and show records if there are any in that day and 0, if there are none.