How do I ADD the same Column of Numbers in PHP MySQL SELECT QUERY?

Phil M

New member
I am trying to do something simple.

I have 1 column in 1 table and I want to add them and echo the total.

"SELECT fees FROM feetable WHERE DATE_SUB(CURDATE(),INTERVAL 0 DAY) <= thedate ORDER BY timestamp DESC";

Need to add fees of the current date.
How do I do that?
Imagine I have these columns:
Fullname City State Fees Timestamp

Now I have my query setup to select the fees for todays date only.

How can I add the fees and total them and then do this

echo $totalfees;
 
Back
Top