[TrickyD]

Thanks again for all the help guys, hopefully this is the last I have to bug you about this particular hack.

So I ran the query with the prefix and updated code as

[sql]select count(*) from cmq_subscriptionlog where status=1[/sql]
And it returned the correct number, 95.

So then I entered the following in the plugin manager for the global_start

PHP Code:

$subscribers = $db->query_first("SELECT COUNT(*) AS totalactive FROM " . TABLE_PREFIX . "subscriptionlog WHERE status=1");
$subscribers['totalactive'] = vb_number_format($subscribers['totalactive']); 


I went into my header template and entered $subscribers at the top of the template and saved it.

But when I went back to my board to check it, it displalyed ARRAY

What'd I screw up this time :dead: