I have a table called 'orders' with a column/field for $total
Is there a fast way to: sum($total) by month? (so as to give total sales per month)
Thanks in advance.
mc
[SOLVED] Quick Answer? Sum total column in table
Moderator: General Moderators
- khaki_monster
- Forum Commoner
- Posts: 73
- Joined: Tue Oct 11, 2005 12:36 am
- Location: Philippines
- Contact:
hi!
i supposed that theirz a field for 'month'...
cheerz!
i supposed that theirz a field for 'month'...
Code: Select all
$tot_sales_permonth = "Select SUM('total_fld') From order GROUP BY month_fld";