Outputting the total of a column? Please help me!

[eluser]mrlol1[/eluser]
Hi there,

I've used a 'CRUD generator' plug-in to create a editable database, however - I need a page that displays the total of each column.

My database is in the following sort of structure, so I'm trying to take the column totals.

ID 2 3 4 5

1 1 2 0 4

2 3 9 3 6

3 4 8 2 5

Many thanks in advance,

Ewan