mySQL count(*) query returning a weird value

[zeroality]

$membercount = $db->query_read('SELECT COUNT(*) FROM ' . TABLE_PREFIX . 'user');

Then I have my php file echo $membercount and it displays "Resource ID 15"...

What? I also tried this:

$membercount = $db->query_read('SELECT COUNT(*) FROM ' . TABLE_PREFIX . 'user');

$membercount = vb_number_format($membercount);

That simply makes it display "15". :(

I want to be able to display how many users I have registered on an external forum page so all I need is to get that mySQL query working right. Any help is appreciated.

[Zachery]

Because you did a select count from the ENTIRE table, not a specific field

use

$membercount[users]

[TrueDeath]

try $db->fetch_array instead.