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



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

Heeeelp