title: sum all row from 2 column and use select to display two column
body: <p><strong>example</strong></p>
  
  <pre><code>|like |comment|
  |user1|asd    |
  |user2|awe    |
  |user3|aqw    |
  |user4|atr    |
  |user5|axc    |
  |user6|azw    |
  |user7|       |
  </code></pre>
  
  <p>i have two column and what i wanted to do is to sum all rows inside those column  and fetch the two column but i dont have any idea on how to do it in a query in sql.</p>
  
  <p><strong>result</strong></p>
  
  <pre><code>|like |comment|
  | 7   |   6   |
  </code></pre>
  
  <p>i tried queering it but i can only fetch 1 column i dont know how to do it with two column..</p>
  
  <pre><code>function countpostcomment($puid){
  $sql = "SELECT COUNT(pc_comment) FROM pcomment WHERE post_uid = '$puid'";
  $stmt = $this-&gt;dbh-&gt;prepare($sql);
  $stmt-&gt;execute(array("0"));
  $active_data = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);
  return $active_data;
  } 
  </code></pre>
  
  <p>here is my sample query i haven't tested the whole function only the select cause i dont know if i need to use array or not..</p>