my $dbh = db_open();
my $id = ''; ## //Wird durch Param übergeben ...
my $sql = "SELECT id,name,text FROM test WHERE id=$id";
my $allref = $dbh->selectall_arrayref($sql, { Slice=>[] });
foreach my $test (@$allref) {
$htc->param(
homename => $test->[1],
home => $test->[2]
);
} $dbh->disconnect();