Addition of mysql fields

Question

For instance, all my users have a coins field. I want to be able to collaborate all the coins gained between all the users but unsure of how to query it.

this is my current query, i have tried using this query.

 $query = mysql_query("SELECT `coins` FROM `users` WHERE `coins` > 0");
        echo mysql_result($query, 0);

SELECT SUM(coins) as sum FROM users where coins > 0..

Coder anonymous
– Coder anonymous

2013-04-26 09:21:58 +00:00
Commented Apr 26, 2013 at 9:21 — Coder anonymous
– Coder anonymous, Commented Apr 26, 2013 at 9:21

Montycarlo · Accepted Answer · 2013-04-26 09:22:54Z

1

SELECT SUM(coins) FROM users should work.

ref: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

answered Apr 26, 2013 at 9:22

Montycarlo

7453 silver badges16 bronze badges

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

Comments

Vijendra Singh · Accepted Answer · 2013-04-26 09:23:38Z

1

select SUM(coins) as Total_Coins from users

answered Apr 26, 2013 at 9:23

Vijendra Singh

6283 silver badges15 bronze badges

Comments

Nick · Accepted Answer · 2013-04-26 09:23:42Z

1

You need to use the SUM() function:

SELECT SUM(`coins`) AS `total` FROM `users` WHERE `coins` > 0

answered Apr 26, 2013 at 9:23

Nick

6,3462 gold badges32 silver badges48 bronze badges

Collectives™ on Stack Overflow

Addition of mysql fields

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related