Calculating total of all records of a field?

[FoxhoundX]

I have a field (Clicks), which has numerous users, and each has a different, changing, number. I would like to know how to find the total of this through MySQL.

Thanks 🙂

[larand]

It's actually quite simple, simply use the SUM function that MySQL has built-in.

$sql = "SELECT SUM( item_id ) FROM item_table";

And that is it!