Gossamer Forum
Quote Reply
Last x voted
I'm trying to work a global that will display the last x voted for with the most recent at the top of the list.

I've tried to modify an existing global using these lines but I can't get it to work. Any ideas?

Code:
my $search_db = $DB->table('Links','ClickTrack');
$search_db->select_options ("ORDER BY Created ASC","LIMIT $_[0]");
$sth = $search_db->select ( { ClickType => 'Rate','>=','1' });
Subject Author Views Date
Thread Last x voted MJB 10647 Apr 2, 2010, 2:31 PM
Thread Re: [MJB] Last x voted
Andy 10526 Apr 3, 2010, 4:13 AM
Thread Re: [Andy] Last x voted
MJB 10471 Apr 3, 2010, 7:55 AM
Post Re: [MJB] Last x voted
Andy 10449 Apr 3, 2010, 7:58 AM
Thread Re: [MJB] Last x voted
Andy 10470 Apr 3, 2010, 9:52 AM
Thread Re: [Andy] Last x voted
Andy 10576 Apr 3, 2010, 11:45 AM
Post Re: [Andy] Last x voted
MJB 10443 Apr 3, 2010, 11:57 AM
Post Re: [Andy] Last x voted
MJB 10473 Apr 3, 2010, 12:13 PM
Thread Re: [Andy] Last x voted
MJB 10425 Apr 3, 2010, 3:43 PM
Thread Re: [MJB] Last x voted
Andy 10475 Apr 4, 2010, 12:07 AM
Post Re: [Andy] Last x voted
MJB 10373 Apr 4, 2010, 5:29 AM
Thread Re: [Andy] Last x voted
Matthias70 9847 Jul 2, 2010, 11:25 AM
Thread Re: [Matthias70] Last x voted
Andy 9806 Jul 3, 2010, 12:21 AM
Thread Re: [Andy] Last x voted
Matthias70 9802 Jul 3, 2010, 2:33 AM
Thread Re: [Matthias70] Last x voted
Andy 9832 Jul 3, 2010, 3:03 AM
Thread Re: [Andy] Last x voted
MJB 9793 Jul 3, 2010, 3:22 AM
Post Re: [MJB] Last x voted
Andy 9790 Jul 4, 2010, 1:33 AM