in reply to Re: more dbi issues
in thread more dbi issues

No, you can't do that.

The '@' means whatever is right of '=' should be a list. [] returns a reference to an anonymous array, which is a scalar.

The qw construct is weird indeed. qw allows for a list of barewords separated by whitespace to be considered a list of elements in an array. Putting quotes around them makes it clear he doesn't understand what it does.

What the Anonymous Monk wants is this:
while (@row = $sth5->fetchrow_array) { push @list_of_teamdata, [ @row ]; }
This will push a reference to a copy of the @row array onto @list_of_teamdata.

Then you can access it like this:
print $list_of_teamdata[0][1]; # prints $teamname print $list_of_teamdata[4][2]; # prints $score


Oh, and you might want to consider using placeholders (search for 'placeholder' in the DBI manpage)...

[ar0n]