title: PHP Mysqli query update not working with variable
body: <p>I have this query:</p>
  
  <pre><code>$date = "january";
  mysqli_query($connection-&gt;dbconn, "UPDATE monthly_visitors SET '$date' = 0");
  </code></pre>
  
  <p>But for some reason it does not work. The variable doesn't seem to work inside the query. Ideas why this is happening?</p>