While all the methods given are fine. . . there is a better, more efficient way. In stead of getting an array and assigning it to an hash, why not just get a hash? For example:

$hash_ref = $sth->fetchrow_hashref('NAME_lc');

[download]

NOTE: NAME_lc was passed so all names are converted to lower case(a _uc would cause upper case). This is because some databases change the case rather whimsically, for their own reasons. This way you can be sure that you are accessing the correct name.

(Programming The Perl DBI says, however, that in future releases, the DBI will implement the *same* hash return for memory efficiency; i.e., copying the data may be neccessary). UPDATE:I didn't fully answer the question, as arturo pointed out.

In reply to Re: how do i store the result from query into hash by dimmesdale
in thread how do i store the result from query into hash by anjaana78

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.