Females Per Team

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


Max females this round 2

Team Order

Array
(
    [0] => 1
    [1] => 51
    [2] => 56
    [3] => 9
    [4] => 72
    [5] => 83
    [6] => 106
    [7] => 76
    [8] => 20
    [9] => 100
    [10] => 21
    [11] => 102
    [12] => 78
    [13] => 27
    [14] => 19
    [15] => 53
    [16] => 86
    [17] => 8
    [18] => 18
    [19] => 103
    [20] => 65
    [21] => 84
    [22] => 71
    [23] => 68
    [24] => 97
    [25] => 22
    [26] => 44
    [27] => 43
    [28] => 14
    [29] => 33
    [30] => 6
    [31] => 38
    [32] => 24
    [33] => 75
    [34] => 80
    [35] => 48
    [36] => 34
    [37] => 95
    [38] => 10
    [39] => 40
    [40] => 23
    [41] => 15
    [42] => 66
    [43] => 17
    [44] => 110
    [45] => 85
    [46] => 39
    [47] => 91
    [48] => 11
    [49] => 63
    [50] => 16
    [51] => 69
    [52] => 67
    [53] => 52
    [54] => 47
    [55] => 41
    [56] => 31
    [57] => 89
    [58] => 81
    [59] => 108
    [60] => 90
    [61] => 12
    [62] => 5
    [63] => 3
    [64] => 60
    [65] => 42
    [66] => 101
    [67] => 13
    [68] => 105
    [69] => 88
    [70] => 92
    [71] => 109
    [72] => 30
    [73] => 96
    [74] => 2
    [75] => 46
    [76] => 28
    [77] => 25
    [78] => 98
    [79] => 50
    [80] => 45
    [81] => 57
    [82] => 37
    [83] => 70
    [84] => 49
    [85] => 62
    [86] => 4
    [87] => 61
    [88] => 32
    [89] => 58
    [90] => 79
    [91] => 87
    [92] => 74
    [93] => 107
    [94] => 54
    [95] => 36
    [96] => 55
    [97] => 59
    [98] => 26
    [99] => 7
    [100] => 29
    [101] => 111
    [102] => 35
    [103] => 93
    [104] => 94
    [105] => 82
    [106] => 104
    [107] => 73
    [108] => 77
    [109] => 64
    [110] => 99
)

SELECT * FROM players WHERE primaryPosition = 'P' AND assignedTeam = false ORDER BY RAND() LIMIT 111

Selected 111 players for position P

JANIE TURNEY | Sex: Female
Terri Brisebois | Sex: Female
Sylvia Roy | Sex: Female
Mariah Curtis | Sex: Female
Kelly Parrish | Sex: Female
Jennifer Eberhard | Sex: Female
Ceci Cruz | Sex: Female
Casady Marlnee | Sex: Female
Arianna Santos | Sex: Female
Melissa Szymkow | Sex: Female
Jennifer Eberhard | Sex: Female
Pat Sexton | Sex: Male
Jonathan Moore | Sex: Male
Ryan Pigeon | Sex: Male
bill schmidt | Sex: Male
Matt Lesczykowski | Sex: Male
CARL WRIGHT | Sex: Male
Todd Peterson | Sex: Male
Tracy Harris | Sex: Male
Jesse Steele | Sex: Male
David Reeves | Sex: Male
Bob Kenyon | Sex: Male
Jesus Alvalle | Sex: Male
Cruz Luevano | Sex: Male
Michael Bocchicchio | Sex: Male
JOSEPH Lucero | Sex: Male
Rogelio Salazar | Sex: Male
Rogelio Salazar II | Sex: Male
Rick Gardner | Sex: Male
Seth Benenson | Sex: Male
Joshua Orton | Sex: Male
Kasey Quinlain | Sex: Male
Dave Holland | Sex: Male
Kasey Quinlain | Sex: Male
Steve Needles | Sex: Male
Keith Madoerin | Sex: Male
Nate Cruz | Sex: Male
Tj Densmore | Sex: Male
steve Needles | Sex: Male
Luis Castillo | Sex: Male
Tracyy Harris | Sex: Male
Michael Halvorson | Sex: Male
Kevin Donwen | Sex: Male
Jeff Hunter | Sex: Male
Jeffrey Kipp | Sex: Male
Dante Brando | Sex: Male
Patric Jordan | Sex: Male
Ray GILBERTSON | Sex: Male
Nick Sargent | Sex: Male
Mark Vukasin | Sex: Male
William Holland | Sex: Male
THOMAS HANNERS | Sex: Male
Brandon Plumb | Sex: Male
Mike Hayward | Sex: Male
SHANE CLARK | Sex: Male
Derrick Christianson | Sex: Male
Nick Puch | Sex: Male
Adrien Falasco | Sex: Male
Ramon Halsell | Sex: Male
Michael O'Malley III | Sex: Male
Gregory Davilma | Sex: Male
Kenneth Mendoza | Sex: Male
Chris Somers | Sex: Male
Zac Polk | Sex: Male
Naythin Fahey | Sex: Male
Michael Yates | Sex: Male
Dustin Proffer | Sex: Male
Matt Andy | Sex: Male
Donnie Welch | Sex: Male
Juan Zaragoza | Sex: Male
Shawn Wilson | Sex: Male
JARED SMOCK | Sex: Male
Kylor Knee | Sex: Male
Fabian Arredondo | Sex: Male
Michael Corbin | Sex: Male
Eric Tveten | Sex: Male
Joshua Ori | Sex: Male
Michael Woods | Sex: Male
Tyler Lockard | Sex: Male
Richard Schneider | Sex: Male
Julius Woody | Sex: Male
Kevin Birner | Sex: Male
Julius Giron | Sex: Male
Davey Griffith | Sex: Male
Joshua Fletcher | Sex: Male
Gregory Davilma | Sex: Male
Zachary Halferty | Sex: Male
Rob Cotto | Sex: Male
Andrew LaFountain | Sex: Male
Chris Pate | Sex: Male
Devon Yeo | Sex: Male
Garrett Dixon | Sex: Male
Carlos Najera | Sex: Male
Justin Mackiewicz | Sex: Male
Manny Gamez | Sex: Male
Kris Purser | Sex: Male
Gregory Beard | Sex: Male
Michael O'Malley III | Sex: Male
Joshua Boyd | Sex: Male
Humberto Luna | Sex: Male
Joseph Dantuono | Sex: Male
Chris Licurse | Sex: Male
Scott Clemens | Sex: Male
Joseph Martinez | Sex: Male
Joseph Franklin | Sex: Male
Adam Martinez | Sex: Male
SImon Bertholf | Sex: Male
Ray GILBERTSON | Sex: Male
Jesus Alvalle | Sex: Male
Jim Rentsch | Sex: Male
Eric Vogl | Sex: Male

Checking if female can be assigned to team (1)

OK to add female.

INSERT INTO team_rosters (teamID, tournamentID, playerID, firstName, lastName, primaryPosition, secondaryPosition, sex) VALUES ('1', '1', '3889', 'JANIE', 'TURNEY', 'P', 'P', 'Female')