use strict;
use GForum qw/$DB/;

my @posts;
my $db = $DB->table('Post');

$db->select_options("ORDER BY post_time DESC", "LIMIT 10");

my $sth = $db->select('post_id', 'post_subject');

while (my ($tags) = $sth->fetchrow_hashref) {
push @posts, qq|<a href="gforum.cgi?post=| . $tags->{post_id} . qq|;sb=post_latest_reply;so=ASC;forum_view=forum_view_collapsed;">| . $tags->{post_subject} . qq|</a>|;
}

return join '<br>', @posts;