title: MySQL | Unable to run two queries at once
body: <p>I have two tables ("members", "ban"). I'm trying to insert a row into "ban" while at the same time update "members", but it won't allow me. The query fails when I run it on my website (though it works when I execute them individually) but this code works outside of my website (for instance, phpMyAdmin's SQL code executor).</p>
  
  <pre><code>INSERT INTO `ban` ( `mid`, `note`, `date` )
  VALUES ( 51, "Test note", "0-0-0 0:0:0" );
  UPDATE `members`
  SET `banned` = 1
  WHERE `id` = 51
  </code></pre>
  
  <p>Could it be something in my PHP config file? Thanks.</p>
  
  <p><strong>Edit:</strong> I'm running it with a MySQLi object, like so</p>
  
  <pre><code>$mysqli-&gt;query('
      INSERT INTO `ban` ( `mid`, `note`, `date` )
      VALUES ( 51, "Test note", "0-0-0 0:0:0" );
      UPDATE `members`
      SET `banned` = 1
      WHERE `id` = 51
  ');
  </code></pre>
  
  <p>Also, as a side note, is this code considered two queries? I'm limited to 75,000 queries an hour so I'm trying to limit my queries. Thanks.</p>