AccNo $result[0] GeneLocus data aaSequence data AccNo $result[1] GeneLocus data aaSequence data AccNo $result[2] GeneLocus data aaSequence data #### $i=0; my %germline; my @key = ('AccNo', 'GeneLocus', 'aaSequence'); # get top 3 fasta-result-hit rows from germline dB until($i==3){ my $sql = "SELECT DISTINCT AccNo, GeneLocus, aaSequence FROM aaSEQ a, Ig_functional b WHERE a.aaID = b.RecNo AND AccNo = '$result[$i]';"; my $sth = $dbh->prepare($sql) or die "Could not prepare statement: " . $dbh->errstr; if ($sth->execute){ while (($germline{AccNo}, $germline{GeneLocus}, $germline{aaSequence}) = $sth->fetchrow_array){ print "\n$key[$i]\n$germline{$key[$i]}\n\n\n"; } } $i++; } $dbh->disconnect();