Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [carfac] Count UNIQUE

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 1595 Aug 7, 2005, 10:29 PM
Post Re: [carfac] Count UNIQUE
fuzzy logic 1555 Aug 8, 2005, 12:36 AM
Thread Re: [carfac] Count UNIQUE
Andy 1561 Aug 8, 2005, 1:19 AM
Post Re: [Andy] Count UNIQUE
fuzzy logic 1546 Aug 8, 2005, 7:31 AM
Post Re: [Andy] Count UNIQUE
carfac 1547 Aug 8, 2005, 7:34 AM