How do I add value of field in all mysql to one?

Hi guys,

I found the forum from Google so I hope you can help?

At present, I have a mysql table with lots of rows.

One of the rows contains a field called "fee".

Now what I want to be able to do is add up all values of "fee" throughout the table.

I.e:

Structure:
Name, RoadName, Country, Telephone, Fee

Example Rows:
John Smith, 1234 Test Road, UK, 1234567890, 5.00
Joe Blogs, Another Test Road, UK, 111111111, 10.00
Sarah Roberts, Final Test Road, USA, 12345678, 20.00

Desired Outcome:
Total Fee: 35

Please can anyone advise on how to do this/example code??

Much appreciated
Regards
Chris

 

SELECT SUM(fee) FROM table;

 

$query = 'SELECT SUM(fee) as total_fee FROM yourtablename';

 

yes this should do it