Question about selecting/rewarding rank

[Seker]

I've created a Hall Of Fame type page which displays users by their total amount of attacks done. The list is made using ORDER BY:

 $q =
           mysql_query(
                   "SELECT username,userid FROM users WHERE user_level != 0 ORDER BY atotal DESC,userid ASC LIMIT 20",
                   $c);

 

The problem is, I'm trying to set up a cron that rewards the players based on their position on that list. How do I go about doing this? Do I need to make a whole new table, and code out each rank reward by hand? Any insight would be appreciated.