[EMAIL PROTECTED] wrote: > I am trying to send the output of a mysql query to a two dimensional array. > > This is what I've tried using push. > > while (@results = $sth->fetchrow_array ()) > { > $x = $results[0]; > $y = $results[1]; > push (@data,[$x],[$y]); > } > > However, I don't get back a two dimensional array, I get back a single > array of @data. > > Thanks. -Aaron >
Not sure if this is an exercise in how to build an AoA or if you are really just trying to accomplish the goal and move on. In the latter case, you can have DBI do it for you using 'fetchall_arrayref', my $array_of_arrays = $sth->fetchall_arrayref; use Data::Dumper; print Dumper($array_of_arrays); You should probably read the docs for the method, assuming you care about data integrity and error handling, http://search.cpan.org/~timb/DBI-1.48/DBI.pm#fetchall_arrayref HTH, http://danconia.org -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>