been looking all night on net but cannot find ORDER BY Month anywhere.
This is my query:
SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUE FROM monthlycommission WHERE YearPaid= NOW( ) GROUP BY MonthPaid
However when i display this it goes June, March then May
I want to add an order by statement so it will order March, May June and so on.