Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Loop that creates multidimensional array?

by jdlev (Scribe)
on Sep 12, 2013 at 16:53 UTC ( #1053766=perlquestion: print w/ replies, xml ) Need Help??
jdlev has asked for the wisdom of the Perl Monks concerning the following question:

I'm not sure what I'm doing wrong here. I'm running a while loop, and all I want to do is to add another array to a multidimensional array on each pass...

Here's the code:

while ($row = $sth->fetchrow_arrayref()) { @player = [(@$row[0], @$row[4])]; }

It only prints out the last record that the array ran through?

I love it when a program comes together - jdhannibal

Comment on Loop that creates multidimensional array?
Download Code
Re: Loop that creates multidimensional array?
by keszler (Priest) on Sep 12, 2013 at 16:59 UTC
Re: Loop that creates multidimensional array?
by Laurent_R (Vicar) on Sep 12, 2013 at 17:05 UTC

    Try this:

    push @player, [(@$row[0], @$row[4])];
      got it to work with this:
      while ($row = $sth->fetchrow_arrayref()) { @array = (@$row[0], @$row[4]); push @{ $players[$count] }, @array; }

        No need to copy the 2 items to a new array.

        while (my $row = $sth->fetchrow_arrayref) { push @{ $players[$count] }, $row->[0], $row->[4]; }
Re: Loop that creates multidimensional array?
by Anonymous Monk on Sep 13, 2013 at 08:30 UTC
Re: Loop that creates multidimensional array?
by Marshall (Prior) on Sep 13, 2013 at 12:59 UTC
    I am not sure of the objective.
    In general, an SQL query should get the result.
    There is probably some syntax error below, but
    this is the general idea.

    while ( ($dumb, $guru) = ( ($sth->fetchrow)[0,4]) ) { #do something here....with $dumb and $guru... #maybe push [$dumb,$guru] to another array? #but that could be just another SQL query. }

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1053766]
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2014-08-23 09:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (173 votes), past polls