Database and php, scriptproject (football)

guy2know

Hi.

I need some help making groups og teams that will play together in matches, and store everything to MySQL database.

If you can help me, here is the info:

I will have to randomly divide the teams into groups, but there are some things that have to be taken into consideration. For example some of the teams will not be playing early in the morning, because they have other plans at that time. The other thing that should be taken into concideration is which teams that has played together before in the leages. Some teams will play only one day, others will play two days.

Any idea on how I should do this? How can I randomly divide the objects(teams) from the mysql table and save the groupID back into the database?

Ask for more information if you need it.

Thanks for any answers, or pointers I might get.

Blulagoon

You need to think multiple tables here.

Maybe:
1. team_id, team_name
2. match_id, home_team_id, away_team_id, kick_off_date/time
3. result_id, match_id, home_team_goals, away_team_goals
4. league_id, league_name, team_id

You'd then use joins to get the results with team_id and match_id

HTH - Blu

guy2know

Thanks, I have made the tables now, but I still need a way to put them into the table group(GroupID, TeamID) randomly and by these things taken into consideration:

Non-payers will not be put in a group.
Teams will not play teams from the same District and Division.
Only teams from same class will play together.
Max teams in the group will be defined in class(NoOfMatches)
The team must be saved in groupparticipation(GroupID, TeamID)

guy2know

Look at my database here. It's in norwegian, but you might figure it out. :rolleyes:

Blulagoon

Hej,

Don't knock my Norwegian, had to do a presentation to 200 Norwegian doctors in Oslo a while ago and found I had to use the Norwegian language version of IE 5 ........

Non-payers, you could use an enum field with items marked No not displaying.
mt_rand() can generate randon numbers, you can then insert them into a table of fixtures using modulo %2 so you get them in pairs.

Hope this gives you some pointers - Blu

n.b. What software did you use for the database schema ?

guy2know

Thanks for the answer. I'll look into it 🙂

I use a software called "PHPMaker" to view the database. It also makes a webinterface where you can add, delete and change the tables. I mostly use phpmyadmin, but I guess it's useful for some people. Maybe it's useful if you want the php code, which probably was the meaning of the software from the start.

Blulagoon

If I was trying to do what you are doing, I think I might take this approach.
Create a temporary table, and populate it with team_id, league_id and location_id for the teams you want to draw to play each other.

I'd then pick 2 teams by selecting team_id,league_id,location_id, order by mt_rand() limit 2

If the location_id was the same, or the league_id was different (or whatever other parameters apply) I would discard that pairing and select another 2 at random. If the match met my criteria, I would write it to an array and delete the two teams from the temp table and start the process again. Eventually you would hopefully match all teams.

I'd use $numrows=mysql_num_rows($result) to get the number of rows returned by each query, if it was == 0 then I'd know to exit the loop, process the array and probably enter the data into a permenant table.

Hope this helps - Blu

guy2know

That helped me a lot, thanks! 🙂

mick104

guy2know wrote:
That helped me a lot, thanks! 🙂

Search google for a FREE programe Called PHP football
Does exactly what it says on the tin
Mick