my ($query) = our $connect->prepare("SELECT number, name FROM TableName");
  $query->execute();
  my $data = $query->fetchall_arrayref();
  $query->finish;


  foreach $data ( @$data) {

    my %row_data;  # get a fresh hash for the row data

    my ($variable1, $variable2) = @$data;

    $row_data{number} = "$variable1";
    $row_data{name} = "$variable2";
    }
    push(@loop_data, \%row_data);
  }