[Colin F]

Originally Posted by 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]; 


You might also make that "LIMIT 0, 6"