Help needed on first try at Database Query!

[Dean C]

You'll need to put something like this in your PHP file:

PHP Code:

$result_allweight['weight'] = vb_number_format($result_allweight['weight']); 


[EvilCrow]

Originally Posted by Dean C

You'll need to put something like this in your PHP file:

PHP Code:

$result_allweight['weight'] = vb_number_format($result_allweight['weight']); 


Little confused what you mean. :ermm:

[Dean C]

Change this:

PHP Code:

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


To this:

PHP Code:

// ### START TEST WEIGHT COUNT ##########################################
$result_allweight = $DB_site->query_first("
    SELECT COUNT(*) AS users,
    SUM(field7) AS weight
    FROM " . TABLE_PREFIX . "userfield
");
$result_allweight['weight'] = vb_number_format($result_allweight['weight']); 
// ### END TEST WEIGHT COUNT############################################# 


[EvilCrow]

WOOHOO... Thank you very much!!!! :up: :classic:

[Dean C]

You're welcome

[Davey]

Sorry I killed my hard drive, I haven't checked back here for a long time.
No problem, I got your pm, check the reply.
Happy to help.