http://www.perlmonks.org?node_id=930501


in reply to Find odd/even elements of array

You might use array of arrays for you data:
push @studentInfo, [@row];

[download]
Then, $studentInfo[$x][0] contains the ID and $studentIfno[$x][1] the name. If the IDs are uniqe, you may profit from Perl's hashes, so build your structure in a different way:
my %studentInfo;
while (my @row = $sth_queryID->fetchrow){
   $studentInfo{$row[0]} = $row[1];
}

[download]
In this case, $studentInfo{$id} contains the name (and should be renamed to %id_to_name or similar).
Update: see perldsc for details.

In Section Seekers of Perl Wisdom