title: PHP/MySQL - "BEGIN...COMMIT" Not Working
body: <p>I was searching for a way to insert data into two database tables in a single query in such a way that if one failed, neither saved (I don't want orphaned data).  I came across a Stack Overflow question that showed me how to use BEGIN...COMMIT to accomplish this, but it simply is not working.</p>
  
  <p>Here's the query I've set up:</p>
  
  <pre><code>$query = "BEGIN;
              INSERT INTO content_subpages (title, url_referer) VALUES ('$pagetitle','$url_referer');
              INSERT INTO ccm_main_menu (sub_item, sub_item_link,sub_item_sort_order) VALUES ('$pagetitle','$url_referer','$newsort');
              COMMIT;";
  mysql_query($query) or die (mysql_error());
  </code></pre>
  
  <p>I get the following error:
  <code>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 'INSERT INTO content_subpages (title, url_referer) VALUES ('TESTING','testing'); ' at line 2</code></p>
  
  <p>This is my first time using BEGIN...COMMIT, so it's reasonable that I might be doing something wrong, but I followed the syntax of the SQL Fiddle example given by the selected answer to the Stack Overflow question I mentioned (http://stackoverflow.com/questions/12649706/mysql-insert-into-multiple-tables-in-same-query-with-begincommit), but it still won't work.</p>
  
  <p>If I can easily achieve the "all-or-nothing" multiple INSERT result without BEGIN...COMMIT, that would be an acceptable solution.</p>
  
  <p>Thanks in advance</p>