title: Total team /mysql
body: <p>I have an table like this : </p>
  
  <pre><code>PLAYER1_ID       #     PLAYER2_ID   #    SCORE_P1    #   SCORE_P2
  1                        3                  3               5
  4                        2                  5               4
  2                        1                  3               4
  </code></pre>
  
  <p>What is the queries in PDO to get that ? The principle is that I don't know the number of ID... Thank you ! :</p>
  
  <pre><code>PLAYER ID        #    SCORE
  1                      7
  2                      7
  3                      5
  4                      5
  </code></pre>