| | I want to return the results of a series of races, and display them in their final placing (1st, 2nd 3rd etc, which is determined by a total_seconds time field) within each race (which will take place on different event_date days). $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 one line of code if that's possible. Can anyone help? |
