Order By Within Group By

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?

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

SELECT * FROM events ORDER BY event_date DESC, total_seconds;