Hi,

It would have been a great if someone giv help in d below reaquirement since i am beginner in Perl.

I have a table store_details in database which looks like below 

Account    Store     day
E200        ABC       1
E400        EFG        2

[download]

I need to store this in a hashtable(But there wont be any key).Next is to iterate through each rows and get corresponding store numbers for each row.I know the query for that.For eg:I need to put ABC in a query and i will get corresponding store numbers .For eg: for ABC store numbers will be 200,300,400.So i need to creat a new hashtable for which i need to give the corresponding values of ABC to all store numbers.For eg: 

Account   Store   day
E200       200     1 
E200       300     1 
E200       400     1

[download]

Like that i need to do for the second row in hashtable also.

Here since 200,300,400 is for ABC store,i will be assigning the other columns values fo rABC to 200,300,400.Can any one help me in this??Pleasee..

In reply to looping in a hashtable by Ammu

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.