[Colin F]

PHP Code:

$winners = $DB_site->query("SELECT username, gold FROM ".TABLE_PREFIX."user ORDER BY gold DESC LIMIT 7 "); 
while ($winner = $DB_site->fetch_array($winners))
{
$id++;
$uname = "name_".$id;
$ugold = "gold_".$id;
${$uname} = $winner[username]; 
${$ugold} = $winner[gold];
} 


That should work. you can then use the variables $name_1 - $name_7 as well as $gold_1 - $gold_7