# This method returns a reference to an array of array-refs
my $site = $sth->fetchall_arrayref;

##</code><code>##

# This method returns a reference to an array of hash-refs
my $site = $sth->fetchall_arrayref( {} );

##</code><code>##

$template->param( view => $site );