Mine

my $count;
while (was soll da hin?) {
my $ref = $sth->fetchrow_hashref();
$template->param(DATE => $ref->{'date'});
$template->param(NAME => $ref->{'name'});
$template->param(DATUM => $ref->{'datum'});
$count++;
print "$ref->{'date'} : $ref->{'name'}, $ref->{'datum'}";
print "<p>";
}