title: Prepare Statement Fails to Insert Two out of Four Variables
body: <p><a href="https://i.stack.imgur.com/Rtz2S.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rtz2S.png" alt="enter image description here"></a>I added two new fields to a table. The SQL <code>insert into</code> continues to work for the two old fields, but fails to insert any data for the two new fields. The two new fields are <code>$authorflag</code> and <code>$artistflag</code>. These two fields are supposed to be <code>boolean</code> variables.</p>
  
  <p>I have experimented by changing these variables from <code>integer</code> to <code>string</code>, changing their position, and even re-creating the table so that all four fields are new. Despite these tweaks, only the two old variables are actually inserted into the table. The new variables show-up as <code>null</code>.</p>
  
  <pre><code>$authorflag='NNNNNNNN';
  $artistflag=0;
  login();
  $stmt=$conn-&gt;prepare('INSERT INTO tblAuthorList (AuthorLast,AuthorFirst,AuthorFlag,ArtistFlag) Values(?,?,?,?)');
  $stmt-&gt;bind_param('sssi', $lastname,$firstname,$authorflag,$artistflag);
  $stmt-&gt;execute();
  </code></pre>