title: Updating MSSQL table with PHP + sqlsrv
body: <p>I'm trying to do the simplest thing...</p>
  
  <p>I have a form with 2 fields. I want to enter data in those fields and have them write that data to my db (mssql using sqlsrv driver).</p>
  
  <p>Connecting to the db isn't a problem. Here's my form processor (only set up to update quantity (qnty) at the moment):</p>
  
  <pre><code>require_once 'dbconnect.php';
  
  $partno = $_POST["partno"];
  $qnty = $_POST["qnty"];
  
  $sql = 'UPDATE WestDevDB SET LocationQty = $_POST["qnty"]';
  
  $result = sqlsrv_query($conn,$sql) or die(sqlsrv_errors());
  </code></pre>
  
  <p>All I get is the error:</p>
  
  <blockquote>
    <p>Notice: Array to string conversion in filepath\file.php on line 8
    Array</p>
  </blockquote>
  
  <p>and nothing writes.</p>
  
  <p>I've tried changeing <code>$_POST["qnty"]</code> to <code>$_POST["qnty"][0]</code> thinking that would solve the issue, but it makes no difference.</p>
  
  <p>Any thoughts on this?</p>