title: how to insert into two tables using php with transaction?
body: <p>I know inserting into multiple tables with single query is not possible,</p>
  
  <p>now I am trying to insert into 2 tables with php using <code>START TRANSACTION</code> but its not working.</p>
  
  <p>my sql query is looks like</p>
  
  <pre><code>mysqli_query($con,"START TRANSACTION
      INSERT INTO users VALUES ('', '$getuser', '$getpass', '$getemail', '$fname', '$lname', '$domain', '$address1', '$address2', '$city', '$country', '$region', '$zip', '$phone', '$getplan', '$duration', '$getprice', '', '0', '0', '$code', '$date', '$time','0', '', '')
      INSERT INTO domains (username) VALUES ('$getuser') COMMIT");
  </code></pre>
  
  <p>So where is the problem??</p>
  
  <p>many thanks in advance.</p>