How to add up a column of numbers on a search query
Hi Everyone,
Happy Xmas & New Year
Using the search wizard I have set up a simple search to show records from a to and from date and this is working fine
The recordset includes two columns of figures the id's being ' fee ' & ' comm '
I want the search result page to show somewhere at the bottom of the page the totals for
' fee ' & ' comm '
Can this be done on a search results page and if so what code would I need to add. I have a very restricted knowledge of
php and mysql although I suspect that the the SUM statement comes into play some how and an echo statement for the result?
Thanks for your help
Mel