I am tryin to make a league fixture maker for a game league
the current state is i have all the teams playin each other in 1 table 🙂
So i the table tbl_fixtures i have
fixture_id,
team1_id,
team2_id,
Now i am going to have a seperate table called week1_games for the week1 games 🙂
So what i want to do is take 1 occurance from the tbl_fixtures table for each and place into the week1_game
I mean that in the week1 table i should have only 1 occurance of a team_id in ne of the team columns of the week1 table
cos only 1 team can play once per week
I am havin no end of probs and hope ppl on here can help me
I just need some php code to do it plz
Cheers
Stephen
