I question the copying and pasting of your code, but I believe all you need to do is change your line to:
push @$allshows, $shows;
But actually, that's not good enough, because you're always populating the same variable. So do:
for (@ids) {
my $stmt = "SELECT * FROM shows WHERE id = '$_'";
&execute_it( $stmt ); #sub that prepares and executes
while (my $shows = $sth->fetchall_arrayref({})) {
push @$allshows, $shows);
}
}
_____________________________________________________
Jeff
japhy Pinyan,
P.L., P.M., P.O.D, X.S.:
Perl,
regex,
and
perl
hacker
How can we ever be the sold short or the cheated, we who for every service have long ago been overpaid? ~~ Meister Eckhart