how to get the total amount of donors in a donor table mysql

Question

0.00/5 (No votes)

See more:

hello,

in my application i wanted to store donor details ,so i have created a donor table with some field like donor name, amount etc.. same donor can donate amounts any time. so i wanted to get the total amounts donated by each donors is there any way?

Thanks
Ginnas

Posted 27-Mar-13 21:54pm

ginnas

Updated 27-Mar-13 21:55pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Answer 1 · 2013-03-27T22:01:00

Solution 1

You need the SUM function and a GROUP BY clause.
Something like

SQL

SELECT donor, SUM(donation) as TotalAmount
From MyTable
Group By donor

Posted 27-Mar-13 22:01pm

Bernhard Hiller

Comments

ginnas 28-Mar-13 5:25am

Thanks Hiller
it helped me truely, thank you very much
i have few more doubts,in the same table i have to get 1-the donors who donating more than 10000 in year
2-donors who are not donating during the past 2 years
in my table i have one field for storing the donating date

so how can we do this ?

Regards
Ginnas

Shrestha Santosh · Answer 2 · 2013-03-27T23:53:00

Solution 2

Well, you need to use the aggregate function to get the total amount.
And you need to use the Group by clause to group the total amount from each donor.

SQL

select donor, sum(amount) from tbl_x group by donor

that's all.
I hope this helps you.

Posted 27-Mar-13 23:53pm

Shrestha Santosh