From table fixtures i want to remove field opponents and include fields called Team A and Team B (This will validate manager not to select same team eg ARSENAL vs ARSENAL ).
And am i allowed to add another table ?
I might be wrong...
but my understanding is you pick the team you want to write a website for..
i.e ARSENAL
so team A will always be ARSENAL ...
you will only pick a opponent, fixture and a date that Arsenal will be playing against the other team
Thanks but i want to show the headings of fixture like this:
TIMEHOMEAWAYVenue
which means ARSENAL can play away or home ground AND MANCHESTER UTD can play home ground or away. eg you can check http://www.soccerladuma.co.za/ they show whether the team is playing away or home ground.
Again i want to add Field called last_login_date for manager.