title: MySQLi prepared update statement in PHP
body: <p>How do you write a prepared update statement? Reference:<a href="http://php.net/manual/en/mysqli.prepare.php" rel="noreferrer">mysqli::prepare</a></p>
  
  <p>I've tried writing it as described: </p>
  
  <pre><code>  if ($stmt = $mysqli-&gt;prepare("UPDATE tblFacilityHrs SET title =? description = ? WHERE uid = ?")){
              $stmt-&gt;bind_param('sss', $title, $desc, $uid2);
  
              //Get params
              $title=$_POST['title'];
              $desc=$_POST['description'];
              $uid2=$_GET['uid'];     
  
  $stmt-&gt;execute();
              $stmt-&gt;close();
      }
      else {
          //Error
          printf("Prep statment failed: %s\n", $mysqli-&gt;error);
      }
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>Prep statment failed: You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right
    syntax to use near 'description = ? WHERE uid = ?' at line 1 Edited
    row.</p>
  </blockquote>