I am wondering if anything can begin to point me in the right direction...
I am trying to create a fixture generator for a local football league and I can't seem to get my head around where to start.
My idea was to start with getting it working for one of the three divisions and go from there. I don't have a clue how to start on generating the fixtures but I know that I will need find out the total number of teams in the division via a simple query so that it can be stored in a variable and used in the algorithm.
The biggest issue I have is that some teams share pitches and they obviously cannot play on the same game week. Furthermore the teams must play each other once at home and once away.
If anyone could perhaps point me in the right direction or provide any sort of assistance I would be very appreciative. I can't find anything online that generates fixtures and stores them in a database. Ones I have found seem overly complicated and I can't get my head around them.
All help is appreciated.
Thanks.