Return The Sum Of The Same ID

[rochellecanale]

hey guys I need a little help my problem is this:

points_ledger table

Code: Select all

ledger_id      |    date    |   running_balance    |    fkmember   |
    1          |  01/29/12  |          5                 |       1           |
    2          |  02/16/12  |         30                 |       1           |
    3          |  02/30/12  |         500                |       2           |
 

Thats my simple table: Now My Problem is. How can i get the sum of the running_balance of the same fkmember? And my output should be like this when i want to display in PHP.

Code: Select all

fkmember | running_balance |
 1             |        35              |
 2             |         500           |


Please help me guys im in a middle of a project.

[egami]

Is this a school project?

[seandisanti]

Where's your attempt at the work? Can't really expect others to do your homework without at least offering evidence that you've given it a shot