See next post instead - this one is left in for continuity.
as Total from users where `team` = '<team_name>' ORDER BY Total DESC
You will also need to add sum() into your columns that you're selecting too:
select `id`,`driver`, `team`, sum(`aus` + `mal` + `chi` + `bah`) as Total from users where `team` = '<team>' ORDER BY Total DESC;
Tested on a test table in phpmyadmin but you'll need to adjust it for your use.
My helpful sig has gone because a mod below the administrator gave me an infraction - despite the administrator personally agreeing to it.
If you need any php tips or tricks you can PM me.
Last edited by tangoforce; 06-29-2013 at 01:03 PM..