mysql - sorting and calling help

[Tekton]

Basically what I want to do is get the top 7 people with the most 'gold'.

This gives me the top person, but I need a way to get all 7. Any help? Thanks.

PHP Code:

$temp = $DB_site->query_first("SELECT username, gold FROM ".TABLE_PREFIX."user ORDER BY gold DESC LIMIT 7 ");
$top_one = $temp[username];
$top_one2 = $temp[gold];