title: is it possible to utilize two $stmt mysqli
body: <p>Hello I have a question when I use my <code>$stmt</code> to execute an insert query into my database it works perfectly fine, however when I use a <code>$stmt2</code> after that execute to UPDATE a different table it won't update the table even though to my understanding the code is correct.</p>
  
  <p>The code I have tried to fix many times is as so</p>
  
  <pre><code>$mysqli= my database connection
  $stmt = $mysqli-&gt;prepare("INSERT INTO `test_table`(datenow,test1,test2,test3,test4,test5,test6,test7,test8, 
  test9,test10,test11,test12,test14,test15,test16,test17,test18,) 
  VALUES (CURRENT_TIMESTAMP, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)") 
  $stmt-&gt;bind_param('ssssssssssssssssss',$test1,$test2,$test3,$test4,$test5,$test6,$test7,$test8,$test9,$test10,$test11,$test12,$test13,$test14, $test15,$test16,$test17,$test18);
  $stmt1 = $mysqli-&gt;prepare("UPDATE `users` SET productID='1', purchase_date=CURRENT_TIMESTAMP, end_date=DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL 30 DAY) WHERE username = ?");
  $stmt1-&gt;bind_param('s', $username);
  $stmt1-&gt;execute();
  $stmt-&gt;execute();
  </code></pre>
  
  <p>Any help would be very appreciated thanks!</p>