time results

[xwalker]

hi,

 

i have two tables in my database

 

*table teams

 

team_id

team_name

team_result

 

*table participants

 

renner_id

participants_name

team_id

participant_result

 

each team consists of 3 participants who will all have their own result

 

now i am building a page who will show the team results on the left side en the particiants result on the right side

 

the right side is no problem

 

page must be like this

 

Team 2      time team 2  |  Participant 4      time participant 4

Team 4      time team 4  |  Participant 22      time participant 22

Team 8      time team 8  |  Participant 16      time participant 16

Team 6      time team 6  |  Participant 9    time participant 9

Team 3      time team 3  |  Participant 5      time participant 5

Team 1      time team 1  |  Participant 13      time participant 13

Team 7      time team 7  |  Participant 6      time participant 6

....

 

example = team 2 consists of participant 4, 5 and 6

 

so how can i make a code that counts the 3 times (participant 4 - 5 - 6) together to achieve the team result and show them on a page