title: Something going wrong in mysqli_query
body: <p>I am newbie and learning php yet. I am trying to run some mysqli_query but its giving me some errors. My code is like below.</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
  ob_start();
  include("db.php"); 
  $result = mysqli_query($conn,"SELECT * FROM contest");
      while($row = $result-&gt;fetch_assoc()){
          if($row['automated'] ==1){
              echo 'Atomatic is enabled';
              $result1 = mysqli_query($conn,"UPDATE `contest` SET automated =0"
       $new =  mysqli_query($conn,$result1);
        echo 'Atomatic is Disabled';
          }
          else{
              echo 'Atomatic is Disabled';
          }
      }</code></pre>
  </div>
  </div>
  </p>
  
  <p>can somebody check and please suggest me whats wrong in this query ? its giving me error like <strong>Parse error: syntax error, unexpected '$new'</strong> and similar if I change it. Thanks</p>