To get the top 10, you should do something like:
my $search_db = $DB->table('SearchLog');
$search_db->select_options ('ORDER BY Results DESC', 'LIMIT 10');
my $sth = $search_db->select;
while (my $row = $sth->fetchrow_hashref) {
...
}
Cheers,
Alex
--
Gossamer Threads Inc.
my $search_db = $DB->table('SearchLog');
$search_db->select_options ('ORDER BY Results DESC', 'LIMIT 10');
my $sth = $search_db->select;
while (my $row = $sth->fetchrow_hashref) {
...
}
Cheers,
Alex
--
Gossamer Threads Inc.