Mysql multiple SUM in one query - novice

Question

I am counting clicks per category of ads. I am curently passing category to function, I have 10 cats, so I am calling this function 10 times to get number of clicks for each category. So i am trying to figure out is it possible to do in one query. Just started with mysql This is my code:

SELECT SUM(clicks) AS 'clicks' FROM wp_cb_ads_manager WHERE category = '.$cat.'

and this gives me

Array ( [0] => stdClass Object ( [clicks] => 11 ) )

Is it possible to do this on one query, so to retrieve SUM per each category in array. Here is the screen of how 2 tables looks like:

http://awesomescreenshot.com/00018kly6d http://awesomescreenshot.com/06418kltcc

In first i keep list of categories, and in second I keep ads where one field is used to check in which category is ad.

A bit unclear, you may want to add the schema to your question instead of linking to external images. — Joachim Isaksson
– Joachim Isaksson, Commented May 4, 2013 at 18:37

Joachim Isaksson · Accepted Answer · 2013-05-04 18:40:04Z

2

If I'm reading your screenshots correctly, this will display the sum grouped by category;

SELECT category, SUM(clicks) AS clicks 
FROM wp_cb_ads_manager 
GROUP BY category

answered May 4, 2013 at 18:40

Joachim Isaksson

182k28 gold badges297 silver badges307 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Goran Jakovljevic Over a year ago

Thank You! Worked like a charm. Still learning mysql, if i want to sum also one more data like impressions, should i just do: ... SUM(clicks) AS clicks, SUM(impressions) AS 'impressions' FROM....

Joachim Isaksson Over a year ago

@GoranJakovljevic Yes, as long as you want to group them all by the same thing (ie category) that will work well.

Community · Accepted Answer · 2017-05-23 12:04:59Z

1

Try this query

SELECT SUM(clicks) AS 'clicks', count(*), category  FROM wp_cb_ads_manager group by category

It works perfectly.

Refer to this

MySQL SUM when using GROUP BY not working

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered May 4, 2013 at 18:45

Kevin_cl

3692 silver badges8 bronze badges

Comments

PHP Avenger · Accepted Answer · 2013-05-04 18:40:43Z

0

You can achive this by group by statement

SELECT SUM(clicks) AS 'clicks', category FROM wp_cb_ads_manager group by category

Your result set will have sum of clicks against each catrgoty

  clicks   | category
    3      |  goan
    5      |  roan
    8      |  mone

and so on.

answered May 4, 2013 at 18:40

PHP Avenger

1,8117 gold badges40 silver badges74 bronze badges

Collectives™ on Stack Overflow

Mysql multiple SUM in one query - novice

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related