Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Forum : Discussion :

Total of a Field...

Nov 30, 2004, 8:14 AM
SeanP
User (456 posts)
Nov 30, 2004, 8:14 AM
Post #1 of 3
Views: 2376
Shortcut
Quote Reply
Total of a Field...
I added a new field to the users table called "user_stores". This field will contain different values for each user. I am trying to write a global that will add up all of the values in this field for an overall total. Any help would be greatly appreciated.

Sean
Nov 30, 2004, 8:26 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Nov 30, 2004, 8:26 AM
Post #2 of 3
Views: 2322
Shortcut
Quote Reply
Re: [SeanP] Total of a Field... In reply to
For every user?

You could try;

<%global_name%>

Code:
sub {
my $total;
my $sth = $DB->table('User')->select( ['FieldName'] );
while (my ($value) = $sth->fetchrow) {
$total += $value;
}
return $total;
}

This is untested, and will require a little tweaking to match up with your field names ... but it should work :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Nov 30, 2004, 8:54 AM
SeanP
User (456 posts)
Nov 30, 2004, 8:54 AM
Post #3 of 3
Views: 2310
Shortcut
Quote Reply
Re: [Andy] Total of a Field... In reply to
That works great! Thanks Andy!