note jaldhar <p>DBI has a number of functions that let you bypass having to code a loop. (Behind the scenes they are looping so these are just shortcuts really.)</p> <p>if you know you're only going to get one row back, selectrow_array (or _arrayref or _hashref) does the prepare, execute, and fetch all in one go for you.</p> <p>If you want an arrayref of arrayrefs or hashrefs (each representing one row,) the selectall_arrayref or selectall_hashref functions combine prepare, execute, and fetch into one function for you.</p> <p>If you only want certain columns from each row returned as an array of arrayrefs (each representing the selected columns in one row, selectcol_arrayref does the prepare, execute, and fetch in one go just like the other functions.</p> <div class="pmsig"><div class="pmsig-25823"> <p>-- <br>&#2716;&#2738;&#2727;&#2736;</p> </div></div> 689388 689388