Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Subtotals
- Thread starter cogdev
- Start date
sleipnir214
Programmer
MySQL can do the per-category subtotals for you. The grand total you'll have to calculate in PHP.
Given the following data in a table foo:
[tt]+----------+------+
| category | val |
+----------+------+
| a | 1 |
| a | 2 |
| c | 3 |
| c | 8 |
| b | 6 |
| b | 5 |
| d | 4 |
+----------+------+[/tt]
The query:
select category, sum(val) as sum from foo GROUP by category order by category;
will return:
[tt]+----------+------+
| category | sum |
+----------+------+
| a | 3 |
| b | 11 |
| c | 11 |
| d | 4 |
+----------+------+[/tt]
You can then loop through the values, maintaining a variable which accumulates the sums.
Want the best answers? Ask the best questions!
TANSTAAFL!!
Given the following data in a table foo:
[tt]+----------+------+
| category | val |
+----------+------+
| a | 1 |
| a | 2 |
| c | 3 |
| c | 8 |
| b | 6 |
| b | 5 |
| d | 4 |
+----------+------+[/tt]
The query:
select category, sum(val) as sum from foo GROUP by category order by category;
will return:
[tt]+----------+------+
| category | sum |
+----------+------+
| a | 3 |
| b | 11 |
| c | 11 |
| d | 4 |
+----------+------+[/tt]
You can then loop through the values, maintaining a variable which accumulates the sums.
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Status