title: adding up data in a column
body: <p>I have a field <code>caloriesBurned</code> that should keep track of the total work out hours. I want to enter daily values into this field and have the field keep adding up the hours entered i.e monday 2 hrs wed 2 hrs ..<code>caloriesBurned</code> should be populated with 4 hrs....Is this possible? Here is my code.</p>
  
  <pre><code>$monthSum= mysql_query("SELECT caloriesBurned FROM workout WHERE userid = $userid");
  
  $sql = mysql_query  ("UPDATE workout SET caloriesBurned = SUM($monthSum($caloriesToday)) WHERE userid = $userid");
  </code></pre>