note
space_monk
A little known "feature" of <b>fetchall_arrayref</b> is that it will return an array of hashes if you supply it a hash, and if that hash is empty, it will return all the fields.
<code>
my @allrows = @{ $sth->fetchrow_arrayref({}) }; # Expand ref, to simplify access
</code>
<p>YMMV, but I always find it easier to look at <i>$row{language}</i> than <i>$row[2]</i>. I'm sure there's a mild performance hit, but as long as it's not incredibly slow I'd opt for clarity.</p>
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-880879">
A Monk aims to give answers to those who have none, and to learn from those who know more.
</div></div>
1010560
1010598