Jump to content

scheduling


chriscloyd

Recommended Posts

Just randomize the teams not including the team you want to create matches for!

[code]SELECT tid, tname FROM teams WHERE tid != some_team_id ORDER BY RAND() LIMIT 8;[/code]

Then add those results to a [b]games[/b] table to create the games schedule. You can also add more logic to the above query, so you only select teams that are not already playing or that may have already played one another.

me!
Link to comment
https://forums.phpfreaks.com/topic/23632-scheduling/#findComment-107339
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.