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

Re: [Paul] Top ten daily searches...

Quote Reply
Re: [Paul] Top ten daily searches... In reply to
You're right. Thanks, that worked great!

I have another global that gives me a total daily search count. Can you tell me how do I do the same in it?

Code:
sub {

# Gets the current date.
Links::init_date();
GT::Date::date_set_format($CFG->{'date_db_format'});
my $date = GT::Date::date_get();

my ($total) = $DB->table('SearchLogDaily')->select(['SUM(HitCount)'])->fetchrow_array;

if ($total < 1){
$total = '0';
}

return $total;
}

Sean
Subject Author Views Date
Thread Top ten daily searches... SeanP 2574 Sep 26, 2002, 11:58 AM
Thread Re: [SeanP] Top ten daily searches...
Paul 2493 Sep 26, 2002, 12:05 PM
Thread Re: [Paul] Top ten daily searches...
SeanP 2492 Sep 26, 2002, 12:13 PM
Thread Re: [SeanP] Top ten daily searches...
Paul 2465 Sep 26, 2002, 1:07 PM
Thread Re: [Paul] Top ten daily searches...
SeanP 2465 Sep 26, 2002, 1:43 PM
Thread Re: [SeanP] Top ten daily searches...
Paul 2461 Sep 26, 2002, 2:01 PM
Post Re: [Paul] Top ten daily searches...
SeanP 2452 Sep 26, 2002, 4:33 PM