[RESOLVED] Generate Draw for Sporting Event

[Punktorian]

hi! i've just been given a task to do and i've hit a stump! i've got to 'Generate a draw' for a Netball Tournament between different schools. In this i have to do a few specific things such as

• schools that offer their hall be used as a venue their teams have to compete there

• Schools can give one preference as to which venue they want to compete in however if that venue is full and they cant get in they're moved to the default venue (city)

all the information for this is split up into different SQL tables i.e Teams, Schools and Venues, etc
I'm not look for an answer for this entire thing i'm just looking for some ideas on how i should go building this :-)

Thanks in advanced

[dalecosp]

Well, I'll bite. Get the data into PHP and process there.

You'd probably put the venues in an array, then sort by the number of "preference requests". Pull in any school whose location matched (should be just one, right?) and then pull in the first $n schools that preferred that venue (so, for example, if a local tourney is 8 teams, get 7 more). Move on to the next preferred venue and repeat, and so on.

As for the individual matchups, I take it there's no "seeding" of teams?

[Punktorian]

hey thar,

Thanks for responding, Great Idea! but i had JUST solved it before i looked at your reply 😛

will consider that in future though takes note🙂

i'm using my good ole pal the 'if' statement

better mark this as resolved now ain't I🙂

Thanks for your help!