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

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

Selected 111 players for position P

ceci cruz | Sex: Female
Rachel Adaza | Sex: Female
Shawna Cavender | Sex: Female
Minerva Gamez | Sex: Female
JANIE TURNEY | Sex: Female
Arlet Okimoto | Sex: Female
Melanie Thomas | Sex: Female
Neena Avent | Sex: Female
Minerva Gamez | Sex: Female
Shawna Cavender | Sex: Female
ceci cruz | Sex: Female
Christina Ochs | Sex: Female
Joanne Drew | Sex: Female
Jessica Dorn | Sex: Female
Seth Benenson | Sex: Male
Tim Ruffner | Sex: Male
Michael Dominguez | Sex: Male
Jonathon Schooler | Sex: Male
Mike Curry | Sex: Male
Chris Taylor | Sex: Male
Kendall Smith | Sex: Male
Stanley Thomas | Sex: Male
Preston Campbell | Sex: Male
Jordan Grubb | Sex: Male
Chris Schiller | Sex: Male
Kyle Davey | Sex: Male
JAMES DICK | Sex: Male
Kyle Maurer | Sex: Male
Lawrence McCall | Sex: Male
Tracy Harris | Sex: Male
David Elmore | Sex: Male
Billy Mccrary | Sex: Male
Christian Bayer | Sex: Male
RaShodd Stevens | Sex: Male
dusty conner | Sex: Male
Jerry Rivera | Sex: Male
Mike Hayward | Sex: Male
Dominic Casey | Sex: Male
David Archer | Sex: Male
Joey Hartsock | Sex: Male
Ben Leonardi | Sex: Male
Christopher Breen | Sex: Male
Eric Burch | Sex: Male
Adam Mohr | Sex: Male
Austin Burchell | Sex: Male
Kasey Quinlain | Sex: Male
John Peoples | Sex: Male
Shaun Tabon | Sex: Male
Francisco CENTENO | Sex: Male
Robert Abel | Sex: Male
Mike Hayward | Sex: Male
Santos Adams | Sex: Male
Gage Atcheson | Sex: Male
Byron Dugger | Sex: Male
Steven Rickelmann | Sex: Male
Kevin Tippit | Sex: Male
Zach Hoxsie | Sex: Male
Keith Madoerin | Sex: Male
Kenneth Roberts | Sex: Male
Andrew LaFountain | Sex: Male
Stephan Lopez | Sex: Male
Mark Miller | Sex: Male
Darrell Lawson | Sex: Male
Steven Rickelmann | Sex: Male
Kendall Ennis | Sex: Male
Darian Ramos | Sex: Male
Michael Vela | Sex: Male
Derek Eaglin | Sex: Male
Frank Johnson | Sex: Male
Christopher Burnett | Sex: Male
Andy NeSmith | Sex: Male
Rico Yebra | Sex: Male
Jonathan Garcia | Sex: Male
Austin Hoxsie | Sex: Male
Chris Pate | Sex: Male
Jonathan Moore | Sex: Male
Burl Shealy | Sex: Male
Ryan Cassidy | Sex: Male
Derek Miller | Sex: Male
Waldemar Perez Roman | Sex: Male
Gary Barrett | Sex: Male
Justin Davis | Sex: Male
Michael Norsworthy | Sex: Male
Robert Bryant | Sex: Male
Kyle Moore | Sex: Male
Deric Schneider | Sex: Male
BRAD MUNDON | Sex: Male
Dominique Montez | Sex: Male
Bill Schmidt | Sex: Male
Dakota Smith | Sex: Male
Darrell Lawson | Sex: Male
Billy Brown | Sex: Male
Chris Sikelianos | Sex: Male
Avery Wirt | Sex: Male
Austin Fokkema | Sex: Male
Anthony Wells | Sex: Male
Christian Long | Sex: Male
Rogelio Salazar II | Sex: Male
Preston Richardson | Sex: Male
Ryan Pigeon | Sex: Male
Irving Macias | Sex: Male
Matthew Harvey | Sex: Male
Kevin Birner | Sex: Male
Joseph Finau | Sex: Male
Juan Hernandez | Sex: Male
Sherman Roberts | Sex: Male
Matt Ward | Sex: Male
Chris Roman | Sex: Male
Eric Burch | Sex: Male
James Sharp | Sex: Male
Seth Benenson | Sex: Male

Checking if female can be assigned to team (17)

OK to add female.

INSERT INTO team_rosters (teamID, tournamentID, playerID, firstName, lastName, primaryPosition, secondaryPosition, sex) VALUES ('17', '1', '10069', 'ceci', 'cruz', 'P', 'P', 'Female')


Fatal error: Uncaught mysqli_sql_exception: INSERTs are currently disabled on team_rosters in /home/spiderzsoft/dev.spiderzsoft.com/build_teams_by_position.php:179 Stack trace: #0 /home/spiderzsoft/dev.spiderzsoft.com/build_teams_by_position.php(179): mysqli->query('INSERT INTO tea...') #1 /home/spiderzsoft/dev.spiderzsoft.com/build_teams_by_position.php(479): getRandomPlayers('P', Object(mysqli), Array, 2) #2 {main} thrown in /home/spiderzsoft/dev.spiderzsoft.com/build_teams_by_position.php on line 179