Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [pugdog] "Number of reviews" global

Quote Reply
Re: [pugdog] "Number of reviews" global In reply to
I *think* this would work for number 2...

$DB->table('Links', 'Reviews')->count;

It will use the foreign key to do the count and so should return the number of links with reviews.

Alternatively this should work....

my $total = $DB->table('Reviews')->('DISTINCT(Review_LinkID)')->fetchall_list;
Subject Author Views Date
Thread "Number of reviews" global waffle 5377 May 18, 2003, 3:02 PM
Thread Re: [waffle] "Number of reviews" global
pugdog 5237 May 18, 2003, 6:15 PM
Thread Re: [pugdog] "Number of reviews" global
Paul 5234 May 18, 2003, 6:26 PM
Thread Re: [Paul] "Number of reviews" global
afinlr 5219 May 19, 2003, 1:38 PM
Thread Re: [afinlr] "Number of reviews" global
Paul 5226 May 19, 2003, 1:42 PM
Thread Re: [Paul] "Number of reviews" global
afinlr 5225 May 19, 2003, 1:48 PM
Post Re: [afinlr] "Number of reviews" global
Paul 5201 May 19, 2003, 1:54 PM
Thread Re: [afinlr] "Number of reviews" global
Paul 5220 May 19, 2003, 1:59 PM
Thread Re: [Paul] "Number of reviews" global
afinlr 5216 May 19, 2003, 2:07 PM
Post Re: [afinlr] "Number of reviews" global
Paul 5227 May 19, 2003, 2:08 PM
Thread Re: [afinlr] "Number of reviews" global
Paul 5188 May 19, 2003, 2:09 PM
Post Re: [Paul] "Number of reviews" global
afinlr 5202 May 19, 2003, 2:12 PM