my @ar = ();
while (my $hr = $sth->fetchrow_hashref() ) {
  push @ar, $hr;
}
$s->ar = \@ar;
$s->rows = @ar;

##</code><code>##

$s->ar   = $sth->fetchall_arrayref({});
$s->rows = @{$s->ar};

##</code><code>##

# Assume $sth is a valid statement handle
my $params   = $sth->fetchall_arrayref({});
my $template = new HTML::Template (filename => 'file.name');

$template->param(TABLENAME => $params);
print $template->output();

##</code><code>##

<TABLE>
<TMPL_LOOP NAME=TABLENAME>
  <TR><TD><TMPL_VAR NAME=COLUMN1></TD><TD><TMPL_VAR NAME=COLUMN2></TD></TR>
</TMPL_LOOP>
</TABLE>