Handling mutiple rows

[Anonymous Monk]

I am a beginner in perl.Please help in the following requirement.I am asked to query the database which will return multiple rows..For eg consider the below mentioned table in DB:

company name account month

X E200 Jan

Y E200 Feb

1 E300 Jan

I need to first get the details from the above table where company name not betwee "0" and "9".So this will retreieve first 2 rows.Then i need to process each rows taking company name and querying database again.For eg : X returns 2,4,5 from database.So i need to create a temporary table lik gievn below

company name account month

2 E200 Jan

4 E200 Jan

5 E200 Jan

Y E200 Feb

1 E300 Jan

like that i shud do for company name=Y also..Pleas helpp

[Anonymous Monk]

Welcome, see The Perl Monks Guide to the Monastery

See Tutorials->Database Programming->DBI recipes

[NetWallah]

Welcome to the monastery, Ammu.

Please see my response to your question looping in a hashtable.
Thinking about that will help you resolve this issue as well.

[Kenosis]

I am asked to query the database...

Do you have a Perl question?

[Anonymous Monk]

Do you have a Perl question?

Sure he does "Please helpp"