Core php 2 small fixes needy

I need 2 modifications in the [login to view URL] script. 1) The count on the amount of teams is good. But the max is not good. To calculate the max games it must be divided by 2 (rounded up). I see in your query that you entered 12. I will change this so that the update query will update the right max number. 2) The second part is that due to the fact that we generate every league per division we need to know the amount of home games per match day. That variable is not yet know when we generate the 22 rounds, example: Division 1 - Match day 1 (already generated and saved in the database): The Bulls 1 vs Darts 1 Division 2 - Match day 1 (new generation, not yet saved in the database): The Bulls 2 vs Lucky 1 As you can see we have too teams "The Bulls" (1,2), The are belong the the association "Bulls" once we generate the second division, the script dos not know how many teams are playing home in the other division(s). So the max home is not taking into a count. I have a two possible solutions for that one. We create a new database table Table: LinkedGames Columns: GameID TeamID AssociationID MaxHomeGames MatchDay PlayedHome (0 no, 1 yes) The tabled contains at the end 22 lines for "The Bulls 1" Where we see the following information GameID = 100 TeamID = 51 AssociationID = 10 MaxHomeGames = 1 MatchDay = 1 PlayedHome = 1 The tabled contains at the end 22 lines for "The Bulls 2" Where we see the following information GameID = 101 TeamID = 61 AssociationID = 10 MaxHomeGames = 1 MatchDay = 1 PlayedHome = 0 If we insert that information we can identify how many teams from a association are currently playing home per match day and if we do a count we can identify if the max is not yes reached. If yes That game needs to be played at a later match day or he needs to play away R The other solution is to generate the matches for every division all at once