Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [Coyu] Count-Global with conditions

Aug 31, 2004, 10:14 AM
Andy
Veteran / Moderator (18426 posts)
Andy's avatar
Aug 31, 2004, 10:14 AM
Views: 1908
Shortcut
Quote Reply
Re: [Coyu] Count-Global with conditions In reply to
Code:
my $cond = new GT::SQL::Condition;
$cond->add('Field','=','something');
$cond->add('ID','>','10');
my ($total) = $DB->table('Users')->select(['COUNT(Logins)'],$cond)->fetchrow_array;

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!
Subject Author Views Date
Thread Count-Global with conditions Coyu 1957 Aug 31, 2004, 9:22 AM
Thread Re: [Coyu] Count-Global with conditions 		Andy 1908 Aug 31, 2004, 10:14 AM
Thread Re: [Andy] Count-Global with conditions 		Coyu 1897 Sep 1, 2004, 4:24 AM
Thread Re: [Coyu] Count-Global with conditions 		Andy 1896 Sep 1, 2004, 4:33 AM
Post Re: [Andy] Count-Global with conditions 		Coyu 1891 Sep 1, 2004, 5:40 AM