brownafroduck
07-18-2005, 06:11 PM
How would I display the total cash held by a single usergroup on the forum index?
I tried putting this in the index.php:$usergroup1=$DB_site->query_first("
SELECT SUM( uttpoints ) AS sumuttpoints
FROM user
WHERE usergroupid = '10'
");
And then in my template I put $usergroup1
But all that shows up is the word Array. Help. :)
I tried putting this in the index.php:$usergroup1=$DB_site->query_first("
SELECT SUM( uttpoints ) AS sumuttpoints
FROM user
WHERE usergroupid = '10'
");
And then in my template I put $usergroup1
But all that shows up is the word Array. Help. :)