title: Update Status of my table on my database
body: <p>i have my codes here, something wrong on my codes, it cant update my table status and req_acknowledge? someone help me. this is what my system run, when i click the button "close" my table status will update to "closed-acknowledged" and when the status is equal to feedback available" and if not, nothing change to the status.. </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>    &lt;?php
              if(isset($_POST['try'])){
  
  $servername = "localhost";
  $username = "root";
  $password = "";
  $dbname = "elev8groupportal";
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn-&gt;connect_error) {
      die("Connection failed: " . $conn-&gt;connect_error);
  } 
  
  $req_status = mysqli_real_escape_string($conn, $_POST['req_status']);
  
  
  $sql = "UPDATE request SET req_status='Closed-Acknowledgement', req_acknowledge=NOW() WHERE req_code = '".$_POST['req_code201']."' and req_status= 'Feedback Available'"or die (mysql_error()
   );
  
  
  if ($conn-&gt;query($sql) === TRUE) {
   echo "Record updated successfully";
     
  
  } else {
     echo "Error updating record: " . $conn-&gt;error;
  }
  
  $conn-&gt;close();
  
  }
  
             ?&gt;  
                  &lt;form&gt;
                      Company: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;input type="text" value="&lt;?php echo ($dn1['comp_name']); ?&gt;" size="50" readonly&gt;&lt;/input&gt;&lt;br&gt;&lt;br&gt;
                      Type of Request: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;input type="text" value="&lt;?php echo ($dn1['itrf_type']); ?&gt;" size="50" readonly&gt;&lt;br&gt;&lt;br&gt;
                      Date Needed: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;input type="text" value="&lt;?php echo ($dn1['req_dateneeded']); ?&gt;" size="50" readonly&gt;&lt;/input&gt;&lt;br&gt;&lt;br&gt;
                      Project Details: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;textarea name="textarea" rows="2" value=""  cols="50" readonly&gt;&lt;?php echo ($dn1['itrf_details']); ?&gt;&lt;/textarea&gt;&lt;br&gt;&lt;br&gt;
                       FORM STATUS: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;input type="" value="&lt;?php echo ($dn1['req_status']); ?&gt;" size="50" readonly&gt;&lt;/input&gt;&lt;br&gt;&lt;br&gt;
                      _________________________________________________________________________________________________________________
                       &lt;label&gt; Approver Comment:&lt;/label&gt;&lt;br&gt;
                      &lt;i&gt;&lt;textarea rows="3" cols="50" width="100px" id="noter_comment" name="noter_comment" align="right" readonly&gt;&lt;?php echo ($dn1['app_comment']); ?&gt;&lt;/textarea&gt;&lt;br /&gt;&lt;/i&gt;
                        &lt;label&gt; Noter Comment&lt;/label&gt;&lt;br&gt;
                        &lt;i&gt;&lt;textarea rows="3" cols="50" width="100px" id="noter_comment" name="noter_comment" align="right" readonly&gt;&lt;?php echo ($dn1['noter_comment']); ?&gt;&lt;/textarea&gt;&lt;br /&gt;&lt;/i&gt;
                        &lt;label&gt;Request Feedback&lt;/label&gt;&lt;br&gt;
                        &lt;textarea rows="3" cols="50" width="100px"  id="TRF_comment" name="TRF_comment" align="right" readonly&gt;&lt;?php echo ($dn1['TRF_comment']); ?&gt;&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;
                       &lt;button type="submit" class="btn btn-primary" name="try" id="try" &gt;Close Form&lt;/button&gt;
                  &lt;/form&gt; 
                 &lt;/div&gt;</code></pre>
  </div>
  </div>
  </p>