title: Update multiple columns in a row no errors but table is not updated
body: <p>I have tried this code but it does not update my table, can someone tell me where i am going wrong?</p>
  
  <pre><code>&lt;?php
  $TeamNow = $teams-&gt;TeamID-&gt;CurrentValue;
  $GK1  = $teams-&gt;Keeper1-&gt;CurrentValue;
  $GK2  = $teams-&gt;Keeper2-&gt;CurrentValue;
  $link = mysqli_connect("localhost", "root", "", "soccer_team");
  if (!$link) {
      printf("Connection to the database failed. Error: %s\n", mysqli_connect_error());
      exit();
  } else {
  /* update rows */
  mysqli_query($link, "UPDATE teams SET ('keeper1_price', 'Keeper2_Price') VALUES ($GK1,$GK2) WHERE TeamID = $TeamNow");
  printf("Affected rows (UPDATE): %d\n", mysqli_affected_rows($link));
  /* close connection */
  ?&gt; &lt;script&gt;  alert ( &lt;?php echo 'Updated Team No:'; echo $TeamNow; ?&gt;); &lt;/script&gt;
  &lt;?php
  mysqli_close($link);
  }
  ?&gt; 
  </code></pre>