Re: How do you insert data into two tables?
Posted: Wed Nov 24, 2010 3:09 am
Can you please give me a simple transaction template with php?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
mysql_query("START TRANSACTION");
$sql1 = "INSERT INTO domain1(domain, user_id) VALUES('$domain', $user_id)";
$query1 = mysql_query($sql1);
$dom_id = mysql_insert_id($query1);
$sql2 = "INSERT INTO domain2(domain_id, user_id) VALUES($dom_id, $user_id)";
$query2 = mysql_query($sql2);
if($query1 && $query2) {
echo 'Domain inserted successfully.';
mysql_query("COMMIT");
} else {
mysql_query("ROLLBACK");
}