my @frames; my $query = $dbh->prepare("SELECT idFrame, name, colour FROM Frame"); $query->execute(); while (my ($frame) = $query->fetchrow_hashref) { $$frame{'image'} = 'test_thumb.jpg'; push @frames, $frame; } my $vars = { 'frames' => \@frames, }; $template->process("admin_frames.tt", $vars);