my $rows = $GetAssignmentID_sth->rows; if($rows > 0) { while (my ($AssignmentID, $UserCount) = $GetAssignmentID_sth-> fetchrow_array() ) { push(@AssignmentIDs, $AssignmentID); } }