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;
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;