I am looking to order a set of results of a mySQL data by quarter. They have data fields, so I am wondering if I should be doing this in PHP or in the query itself?
if you have date field in the db use it to group with it,
like:
group by QUARTER(date)
of course if you want to take in account the years also
group by YEAR(date) , QUARTER(date)
I would do it in the DB - look up the MySQL function Quarter(Date).
You can use GROUP BY Clause in mysql query and return results as -
group by Quarter(date)
Where Quarter is a pre-defined function in mysql.