Earnings per day with Timestamp
#1

Hi guys

I want to make in business that owners can see how much they are earned per day in last 7 days.For example today is 27.02 so they get in dialog:

21.02.2018 543 $
22.02.2018 339 $
23.02.2018 50 $
24.02.2018 99 $
25.02.2018 404 $
26.02.2018 1254 $
27.02.2018 15 $

I have logs for every purchase.When someone buy X things in Y Market it are stored in logs with date in timestamp format.(I use MySQL)

Now,i just don't know how to get from MySQL sum for every day.I know how to get SUM from last 7 days,but i need for every day especially(From 00:00 to 00:00)

Is it possible?
Thanks
Reply
#2

yes, store the money earned in variables and check this

Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)