Total of all added MySQL rows?

[TJMAudio]

Hi everyone,

Alright I have a table that is "dlnum".  This contains file names and how many times they have been downloaded.  How would I go about looping a query and adding each "dlnum" so I can echo out the total amount of downloads (for all files combined)?

Thanks

[trq]

SELECT SUM(fieldtocount) AS totalcount FROM dlnum;