note
albert
with something like this:
<code>
my $ref = $sth->fetchall_arrayref();
my $second_name = $ref->[1]->[1];
</code>
To iterate over all the results and print them, you could do:
<code>
my $ref = $sth->fetchall_arrayref();
foreach my $inner (@$ref){
print join ("\t", @$inner), "\n";
}
</code>
-albert
449914
450097