I have a bit of a problem. I am in the middle of developing a site that needs to use transactions. I have several different tables that comprise a single insert form. Table A, B and C all require transactions.
From what I understand, mysql_query does not support multiple queries. I have several problems that I will list.
1. autocommit is turned off and my script needs to issue "COMMIT"
2. mysql_insert_id() will NOT get the last id until the COMMIT has been issued so returns false.
Basically, I cannot insert data into table B without first knowing the last_id from table A.
I can't get around how to accomplish this.
Can someone please give a hand?