title: ql-No Mysql error but database table not updating
body: <p>I am running a script with no mysql errors but nothing is being written in the database table.</p>
  
  <pre><code>$team1 = 75;
  $con = mysqli_connect("localhost","user","pwd");
  if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
  mysqli_select_db($con,"database") or die ("no database");
  
  $sql=" update TABLENAME set 
  GAME1 = case when GAME1 = '' then $team1 else GAME1 end,
  GAME2 = case when GAME2 = '' then $team1 else GAME2 end,
  GAME3 = case when GAME3 = ''  then $team1 else GAME3 end
  WHERE ID = 140 ";
  if (!mysqli_query($con,$sql))
    {
    die('Error: ' . mysqli_error($con));
    }
  echo "1 record added";
  
  mysqli_close($con);
  </code></pre>
  
  <p>When I ran the php code, it echoes "1 record added", but there’s no record added in   the table.</p>
  
  <p>What is wrong? </p>
  
  <p>Thanks.</p>
  
  <p>EDIT</p>
  
  <p>When I ran echo $sql; I get this:</p>
  
  <pre><code>update TABLENAME set GAME1 = case when GAME1 = '' then 75 else GAME1 end, GAME2 = case when GAME2 = '' then 75 else GAME2 end,GAME3 = case when GAME3 = '' then 75 else GAME3 end WHERE ID = 140 
  </code></pre>