0
hello gentlemen I’m studying php and msqli I’m having a hard time to make a ranking prq the team plays as visitors but sometimes as a boss so I need to add when it appears in both situations. for example {time 1x time2} and {time 3 x time 1} I made a coping table that already serves as an agenda. The problem is I can’t bring that data back from just one situation and not both. in case anyone can help me or give me another idea of how to make this ranking thank you. that’s the code I’m using.
SELECT id
, timea_id
, SUM(),
timeb_id
, SUM(golb)
FROM agenda
WHERE timea_id=2