Battle of the Hubs coding help

[Taran]

Here's what I'm wanting to do:

1. have a box on the home page that display the top 5 hubs by different stats (hours, flights, passengers, miles, etc.).

2. I want this to automatically change each month so it's based off of monthly stats.

3. I will change which stats it calculates each month.

4. I want it to automatically place the hub with the highest stat as #1 and the hub with the 2nd most at #2 etc. etc.

Anyone know the code for how i could do this?

Thanks In Advance!

EDIT: I scratched out the things i've gotten done.

[Taran]

i got the stats to show, but now how do i get them to automatically order themselves for greatest to least?

[SkiesTheLimit]

I would be interested in this code as well.

[flyalaska]

So would I

[Taran]

Still interested in this code for anyone who could help

[Tom]

Still interested in this code for anyone who could help

Sounds like you made some progress on it?

If you still have that, pop it up on GitHub and we can contribute to it

[hurkulez]

$sql= call data field here SORT (ASC)