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