I have a MySQL DB and I am trying to set up a report page. To do so I need to be able to add the data in 6 or 7 fields into a single field for use in a summary report.
How can I do that? SUM() seems to consider only one field at a time.
For example, if I had a zoo database with the following fields:
Date| Lions| Tigers| Bears
1/1 | 2 | 3 | 2
1/2 | 1 | 0 | 2
1/3 | 0 | 2 | 3
I would want to generate a report that would tell me the date and the total number of animals added to the zoo for that date. 1/1 = 7; 1/2 = 3; 1/3 = 5
Any ideas? All help greatly appreciated!!