$search = 'NEW';
    $query = "SELECT id, first_name, middle_name, last_name, age, month, day, year, birth_place, gender, martial_status, religion, nationality, email_address, address_1, address_2, course, school_graduated, remarks, note, date_added, crew_status, image_name, updated_photo, passport_registration, passport_expiration FROM `crew_info` WHERE `crew_status` = ?";
    $stmt = mysqli_prepare($conn, $query);
    mysqli_stmt_bind_param($stmt, 's', $search);
    mysqli_stmt_execute($stmt);
    mysqli_stmt_bind_result($stmt, $id, $first_name, $middle_name, $last_name, $age, $month, $day, $year, $birth_place, $gender, $martial_status, $religion, $nationality, $email_address, $address_1, $address_2, $course, $school_graduated, $remarks, $note, $date_added, $crew_status, $image_name, $updated_photo, $passport_registration, $passport_expiration);