Create a global with the following code:
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY Add_Date DESC', 'LIMIT 1');
my $sth = $search_db->select;
while (my $hit = $sth->fetchrow_hashref) {
$output .= qq!
$hit->{Title}<BR>$hit->{URL}
$hit->{Description}!; }
return $output;
~;
You can try that out but Im not sure if it is correct as I can't remember the table names of the top of my head.
Paul Wilson.
new - http://www.wiredon.net
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY Add_Date DESC', 'LIMIT 1');
my $sth = $search_db->select;
while (my $hit = $sth->fetchrow_hashref) {
$output .= qq!
$hit->{Title}<BR>$hit->{URL}
$hit->{Description}!; }
return $output;
~;
You can try that out but Im not sure if it is correct as I can't remember the table names of the top of my head.
Paul Wilson.
new - http://www.wiredon.net