title: SQL - PHP Multiple Set
body: <p>im busy trying to set multiple fields in my DB and it is not working for some reason. Can you take a look and let me know where i have gone wrong? Thank you</p>
  
  <pre><code>&lt;?php
  error_reporting('E_ALL');
  include 'db_header.php';
  
  $id = $_GET['ID'];
  $bronzeTokens = $_GET['bronzeTokens'];
  $silverTokens = $_GET['silverTokens'];
  $goldTokens = $_GET['goldTokens'];
  $platinumTokens = $_GET['platinumTokens'];
  
  $sql = "UPDATE Player SET bronzeTokens = $bronzeTokens, goldTokens = $goldTokens, silverTokens = $silverTokens, platinumTokens = $platinumTokens WHERE ID = $id";
  $result = $conn-&gt;query($sql);
  ?&gt;
  </code></pre>