getting sum of a query daily
I have a database that has the following:
I need a query that will give me the sum of views and sum of clicks for items that have similar website_id but I need to get the sum daily. when I write:
it just gives me the total of all the days, how can I write this appropriately?
SELECT SUM(`views`) FROM `table` WHERE `website_id` = '1' ORDER BY `created_on`
Try a "group by" instead of "order by"?
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)