Daily Record Count

[blueberries]

I am building an application that records show bookings for a resort company. They would like to have the previous 5 days as well as the current days, daily totals list automatically.

Todat - ##
Yesterday - ##
Day Before Yesterday - ##
2 days before yesterday - ##
So on and so on -##
to five days out - ##

I am thinking something with the Current date function and a repeating records function. Any help would be appreciated.

[ronverdonk]

Welcome to The Scripts!

You are double posting.

Read the Posting Guidelines before you post in this forum!.

Your double thread is removed from this forum.

moderator

[ronverdonk]

Have a look at the MySQL date and time functiuons. What you need to accomplish your requirement are the CURRENT_DATE() and DATA_SUB() functions.

Further information can be found in the MySQL documentation at http://dev.mysql.com/doc/refman/5.1/...functions.html

Ronald :cool:

[blueberries]

That seems to work to give me a running total for 5 days... how would I use this to give me a list of daily totals. I am using PHP btw? I saw another similar question that used the group fuction am I able to group dates?

[ronverdonk]

Nothing to do with PHP, this is pure SQL. And indded, you must use the GROUP BY to get a total for ech group you want the totals from. So for yor query that is something like

SELECT date, SUM(value) AS total FROM table_name 
   WHERE date BETWEEN '2007-01-10' AND '2007-01-12' 
   GROUP BY date;

You can replace the specified dates with your own selections.

Ronald :cool: