push @$allshows, $sth->fetchall_arrayref({});
...
print Dumper(@$allshows);

    $VAR1 = [{
            'title' => 'All Bets Are Off',
            'type' => '2',
            'number' => '215',
            'id' => '1'
            }];
    $VAR2 = [{
            'title' => 'Who Is My Neighbor',
            'type' => '2',
            'number' => '217',
            'id' => '2'
            }];