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

Re: [Paul] How to convert this to a global?

Quote Reply
Re: [Paul] How to convert this to a global? In reply to
   

sub {
my ($output,$sth,$link);
my $search_db = $DB->table('Links','ClickTrack');
$search_db->select_options ('ORDER BY Created DESC Limit 20');
$sth = $search_db->select;
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link', $link);
}
return $output;
}

This one displays ID's and Titles OK BUT the links are ordered by ID Frown



Basically, I only need

SELECT Created FROM dir_ClickTrack ORDER BY Created DESC LIMIT 0, 20

and it works great in SQL Monitor, but I also want ID's and Titles Unsure

Heeeelp Tongue
Subject Author Views Date
Thread How to convert this to a global? Payooo 3617 Nov 10, 2002, 7:01 PM
Thread Re: [Payooo] How to convert this to a global?
Andy 3507 Nov 11, 2002, 1:30 AM
Thread Re: [Andy] How to convert this to a global?
Payooo 3508 Nov 11, 2002, 5:06 AM
Thread Re: [Payooo] How to convert this to a global?
yogi 3485 Nov 11, 2002, 5:10 AM
Thread Re: [yogi] How to convert this to a global?
Payooo 3425 Nov 11, 2002, 10:33 PM
Thread Re: [Payooo] How to convert this to a global?
Alex 3397 Nov 14, 2002, 3:45 PM
Thread Re: [Alex] How to convert this to a global?
Payooo 3396 Nov 15, 2002, 2:01 AM
Thread Re: [Payooo] How to convert this to a global?
Paul 3431 Nov 15, 2002, 2:05 AM
Post Re: [Paul] How to convert this to a global?
Payooo 3404 Nov 15, 2002, 2:37 AM