title: MySQL Transaction - BEGIN Issues
body: <p>I've never used Transactions before but I want to ensure that when I the data into the database via my HTML Form, that should there be an issue, there is a rollback.</p>
  
  <p>Sounds awesome, but I'm struggling to fully understand the place and use of them in a MySQL Query.</p>
  
  <pre><code>$sql = "BEGIN
  
          /* Insert the user to the WordPress Database */
          INSERT INTO wp_users (user_login, user_pass, user_email)
          VALUES ('John', 'Doe', 'john@example.com');
  
          /* Insert the user into our Custom Database */
          INSERT INTO users (ID, name)
          VALUES (LAST_INSERT_ID(), 'John')
  
          COMMIT";
  </code></pre>
  
  <p>I've edited some of the code to be easier to read, and I know for example the password isn't secure, but am I doing something wrong with the BEGIN &amp; COMMIT functions for the Transaction?</p>
  
  <p>I'm also trying to use Transactions so that I can make full use of the LAST_INSERT_ID() function. This should then allow me to ensure that between both Databases, the user will share the same ID so I can easily call upon their unique data for various website application reasons.</p>
  
  <p>I've found a few things online, but none really provide an easily understood example. What exactly am I doing wrong? Is my implementation terrible, or am I just missing something? Is the LAST_INSERT_ID() going to work like that?</p>
  
  <p>I'd greatly appreciate any help you can offer. Thank you.</p>