bittondb has asked for the wisdom of the Perl Monks concerning the following question:
I'm working with an array ref of array refs. This array is the return values from fetchall_arrayref
Code in use:
my $table = $sth->fetchall_arrayref;
Now, I use this array the build a select box. Then I need to fetch a single "row" from $table based on an initial value (a row id). I come from the school of thought that I should just go back to the DB and fetch the single value, but if I already have the table (in $table), then why make the trip to the DB again? I tried messing with map and an anonymous sub but to no avail. I wanted to avoid using a foreach, which I certainly could use, but not as sexy as map. So, what do I do?