Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Re: [carfac] Count UNIQUE

Aug 8, 2005, 12:36 AM
fuzzy logic
Enthusiast (854 posts)
Aug 8, 2005, 12:36 AM
Views: 2241
Shortcut
Quote Reply
Re: [carfac] Count UNIQUE In reply to
I believe you can do:

$DB->table("Links")->select("count(distinct(field))")->fetchrow();

works from SQL monitor...

Code:
select count(distinct(Title)) from site_Links

Your query returned 1 rows.

289

Philip
------------------
Limecat is not pleased.
Subject Author Views Date
Thread Count UNIQUE carfac 2298 Aug 7, 2005, 10:29 PM
Post Re: [carfac] Count UNIQUE 		fuzzy logic 2241 Aug 8, 2005, 12:36 AM
Thread Re: [carfac] Count UNIQUE 		Andy 2249 Aug 8, 2005, 1:19 AM
Post Re: [Andy] Count UNIQUE 		fuzzy logic 2241 Aug 8, 2005, 7:31 AM
Post Re: [Andy] Count UNIQUE 		carfac 2234 Aug 8, 2005, 7:34 AM