title: HTML Button to Update Mysql table
body: <p>I am trying to UPDATE a row from a MySQL Table with a button in my html page. When i press the button it outputs "Query failed". What should I change to make it work ?</p>
  
  <p>My Html Code:</p>
  
  <pre><code>&lt;form action="status1.php"&gt;
       &lt;input type="submit" name="approve" value=" + "&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>My Php Code:</p>
  
  <pre><code>&lt;?php
  require_once('config.php');
      $errmsg_arr = array();
      $errflag = false;
      $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
      if(!$link) {
          die('Failed to connect to server: ' . mysql_error());
      }
      $db = mysql_select_db(DB_DATABASE);
      if(!$db) {
          die("Unable to select database");
      }
  $qry="UPDATE applications SET (status) values('1') WHERE today='$today'";
  $result = mysql_query($qry);
      if($result) {
          header("location: applications-admin.php");
          exit();
      }else {
          die("Query failed");
      }
  ?&gt;
  </code></pre>