i need to achieve a relationship between a user table and a sport rating table.
I explain :
In my rating table i have :
The name of the opponents
A case that show if i win or i loose
The number cote (rating of my opponent)
My rating cote
The date of the match
The number of points i win (if i win)
The number of points i loose ( if i loose)
Where i play the match or the name of the competition
What i need is that when a user is logged in, the name will be recognized and i can see all my matchs and informations about them and my rating cote …
for example you can have many matchs per user so i don’t know how i can do that and how can each user of my database (wich is a player) see all informations of their matches.