my @loop_data = (); while ( my @rw = $sth->fetchrow_array ) { my %row_data; $row_data{ID} = $rw[0]; $row_data{USERNAME} = $rw[1]; $row_data{TIME} = $rw[3]; push( @loop_data, \%row_data ); } $template->param( VIEW_DATA => \@loop_data ); print $template->output();