Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
[6] => 0
[7] => 0
[8] => 0
[9] => 0
[10] => 0
[11] => 0
[12] => 0
[13] => 0
[14] => 0
[15] => 0
[16] => 0
[17] => 0
[18] => 0
[19] => 0
[20] => 0
[21] => 0
[22] => 0
[23] => 0
[24] => 0
[25] => 0
[26] => 0
[27] => 0
[28] => 0
[29] => 0
[30] => 0
[31] => 0
[32] => 0
[33] => 0
[34] => 0
[35] => 0
[36] => 0
[37] => 0
[38] => 0
[39] => 0
[40] => 0
[41] => 0
[42] => 0
[43] => 0
[44] => 0
[45] => 0
[46] => 0
[47] => 0
[48] => 0
[49] => 0
[50] => 0
[51] => 0
[52] => 0
[53] => 0
[54] => 0
[55] => 0
[56] => 0
[57] => 0
[58] => 0
[59] => 0
[60] => 0
[61] => 0
[62] => 0
[63] => 0
[64] => 0
[65] => 0
[66] => 0
[67] => 0
[68] => 0
[69] => 0
[70] => 0
[71] => 0
[72] => 0
[73] => 0
[74] => 0
[75] => 0
[76] => 0
[77] => 0
[78] => 0
[79] => 0
[80] => 0
[81] => 0
[82] => 0
[83] => 0
[84] => 0
[85] => 0
[86] => 0
[87] => 0
[88] => 0
[89] => 0
[90] => 0
[91] => 0
[92] => 0
[93] => 0
[94] => 0
[95] => 0
[96] => 0
[97] => 0
[98] => 0
[99] => 0
[100] => 0
[101] => 0
[102] => 0
[103] => 0
[104] => 0
[105] => 0
[106] => 0
[107] => 0
[108] => 0
[109] => 0
[110] => 0
)
Connected successfully
Array
(
[0] => 60
[1] => 25
[2] => 26
[3] => 106
[4] => 85
[5] => 6
[6] => 55
[7] => 108
[8] => 111
[9] => 74
[10] => 95
[11] => 7
[12] => 10
[13] => 92
[14] => 67
[15] => 44
[16] => 30
[17] => 66
[18] => 29
[19] => 20
[20] => 58
[21] => 49
[22] => 76
[23] => 91
[24] => 102
[25] => 32
[26] => 51
[27] => 43
[28] => 4
[29] => 27
[30] => 75
[31] => 3
[32] => 15
[33] => 73
[34] => 109
[35] => 101
[36] => 34
[37] => 84
[38] => 71
[39] => 104
[40] => 88
[41] => 52
[42] => 16
[43] => 31
[44] => 39
[45] => 56
[46] => 13
[47] => 65
[48] => 17
[49] => 11
[50] => 57
[51] => 103
[52] => 93
[53] => 83
[54] => 72
[55] => 1
[56] => 70
[57] => 53
[58] => 79
[59] => 19
[60] => 47
[61] => 8
[62] => 33
[63] => 5
[64] => 28
[65] => 61
[66] => 46
[67] => 23
[68] => 105
[69] => 69
[70] => 87
[71] => 36
[72] => 48
[73] => 50
[74] => 100
[75] => 12
[76] => 86
[77] => 24
[78] => 77
[79] => 78
[80] => 2
[81] => 80
[82] => 99
[83] => 62
[84] => 89
[85] => 41
[86] => 54
[87] => 63
[88] => 110
[89] => 64
[90] => 107
[91] => 14
[92] => 42
[93] => 38
[94] => 90
[95] => 35
[96] => 9
[97] => 22
[98] => 97
[99] => 37
[100] => 40
[101] => 21
[102] => 82
[103] => 18
[104] => 98
[105] => 59
[106] => 68
[107] => 81
[108] => 96
[109] => 45
[110] => 94
)
Selected 111 players for position P
JANIE TURNEY | Sex: FemaleChecking if female can be assigned to team (60)
OK to add female.
INSERT INTO team_rosters (teamID, tournamentID, playerID, firstName, lastName, primaryPosition, secondaryPosition, sex) VALUES ('60', '1', '3889', 'JANIE', 'TURNEY', 'P', 'P', 'Female')