Help needed on first try at Database Query!

[EvilCrow]

In my FORUMHOME Template i have :

$header
<center><b>Total Member Weight Loss is :</b> <b><font color="red">$result_allweight</font></b></center>
$navbar

In my Index.php of the forums I have :

// ### START TEST WEIGHT COUNT ##########################################
$result_allweight = $DB_site->query_first(" 
   SELECT SUM(field7) AS total
   FROM " . TABLE_PREFIX . "userfield 
");
// ### END TEST WEIGHT COUNT#############################################

Hope thats better so you guys understand whats I have going on.. and BTW I can't thank you guys enough for the help...