NR------E-mail----------Comment---------Dates-------------Age--Action_date
12------Tom@info.com----blablabla-------AM0,PM0,AM1,PM1---32---10-10-2001
13------Frank@info.com--blablabla-------AM0,PM0-----------45---10-10-2001
14------Sand@info.com---blablabla-------AM1,PM1,PM2-------47---10-10-2001
14------Sand@info.com---blablabla-------AM1,PM1,PM2-------47---12-10-2001
####
while (my $c = $st->fetchrow_hashref)
{
my %analyst_record;
$a_record{$c->{ANA_ID}}{e_mail}=$c->{EMAIL}};
$a_record{$c->{ANA_ID}}{Dates}{comment}=$c->{DETAIL};
$a_record{$c->{ANA_ID}}{Dates}{$c->{ACTION_DATE}}{$c->{AM_0}}=$c->{AM_0};
$a_record{$c->{ANA_ID}}{Dates}{$c->{ACTION_DATE}}{$c->{AM_1}}=$c->{AM_1};
$a_record{$c->{ANA_ID}}{Dates}{$c->{ACTION_DATE}}{$c->{AM_2}}=$c->{AM_2};
$a_record{$c->{ANA_ID}}{Dates}{$c->{ACTION_DATE}}{$c->{AM_3}}=$c->{AM_3};
$a_record{$c->{ANA_ID}}{Dates}{$c->{ACTION_DATE}}{$c->{AM_4}}=$c->{AM_4};
####
Show_analyst_row(\$analyst_record{$c->{ANA_ID}});
sub Show_analyst_row
{
my(%analyst_record) = %{@_};
print "$analyst_record{e_mail}\n";
}