Join Troubles

[mikeschroeder]

I have two tables.

contributors and contributions

the contributors table has the following columns

contributor_id, contrib_name,contrib_company,contrib_level,state_id,aff_id ,contrib_date

the contributions table has the following columns
contribution_id,contributor_id, contrib_amount, contrib_commit, contrib_date

So I have a script that parses a bulk upload file with hundreds of records into those two tables, the contributors are each unique there are no duplicates. Then in the second table every contribution each person has made is stored.

So
Contributor 1
-> Contribution 1
-> Contribution 7
-> Contribution 8

etc etc

I can return all the information without a problem. But i need to be able to add the values in "contrib_amount" to have a single result.

This is what is tripping me up, and maybe i'm missing something really simple but its killing me.

Is there anything I can do in a query to pull the results, or is there some way i should be processing it with php after i get it back?

Thanks for any suggestions.

Mike

[shu]

I am going out on a limb as to guess what you trying to accomplish here now. Are you wanting to tally up the contributions for each contributors? If so:

SELECT a.contributor_id, SUM(b.contrib_amount) AS total_contrib_amount 
FROM contributors a, contributions b 
WHERE a.contributor_id=b.contributor_id 
GROUP BY a.contributor_id

[mikeschroeder]

That looks exactly like what i needed. That makes me feel real stupid for not having thought of that sooner.

thanks for your help.

[bradgrafelman]

Don't forget to mark this thread resolved (if it is).