Order By Within Group By

[MacFly 0]

I want to return the results of a series of races, and display them in theirfinal placing (1st, 2nd 3rd etc, which is determined by a total_seconds timefield) within each race (which will take place on different event_datedays).$Query="SELECT * FROM events GROUP BY event_date ORDER BY total_seconds";won't cut it (even I can see why!) but I can't think how to.I suppose I *could* go to two tables and JOIN but I'd rather use just oneline of code if that's possible.Can anyone help?

[nooc 0]

Perhaps you pnly want to sort the table, first by date, then by time?

SELECT * FROM events ORDER BY event_date DESC, total_seconds;