my $ordno = 1; while (my $ref = $GetWOData->fetchrow_hashref()) { print "$ref->{'Ord_No'}\n"; print "$ref->{'Item_No'}\n"; print "\n"; #Qty of parts print "$ref->{'Item_Desc_1'}\n"; print "\n"; #Num of skids print "$ref->{'Cus_Name'}\n"; push @{$orders[$ordno]}, "$ref->{'Ord_No'} | $ref->{'Item_No'}"; push @{$orders[$ordno]}, "0"; push @{$orders[$ordno]}, "$ref->{'Item_Desc_1'} | $ref->{'Item_Desc_2'}"; push @{$orders[$ordno]}, "0"; push @{$orders[$ordno]}, "$ref->{'Cus_Name'}"; $ordno++; } $GetWOData->finish();