title: Add rows together
body: <p>I have one table with some rows and lot of columns (about 50)
  - I don't want to list all the column names, co I use a while loop to go through the table and a foreach command to find the column names and values.
  Now I would like to add these two rows into one row (where id is 1) and sum the values together...</p>
  
  <pre><code>id | col 1 | col 2 | ...
   1    30      21
   1    11      16
   2    75      0
  </code></pre>
  
  <p>It should look like this</p>
  
  <pre><code>id | col1 | col2 | ...
   1    41     37
   2    75      0
  </code></pre>
  
  <p>This is what I have...</p>
  
  <pre><code>$query = mysql_query("SELECT * FROM `table` WHERE `id`='1'");
  while ($row = mysql_fetch_assoc($query)) {
      foreach($row as $key =&gt; $val) {
          if($key != 'id') {
              //the sum code...?
          }
      }
  }
  </code></pre>
  
  <p>Could you please help me? Thank you a lot...</p>