I have a problem with the code below. The script is meant to insert the values collected from a form and be inserted into two tables namely the client table(main) and a clientchild table(child) repectively.
The members's values are inserted well but the problem is that the clientchild's values aren't added, but when I interchange the codes, they are added to the child table and vis a vis.
any help will be appreciated.
thank you in advance.
here's the code
$new_name = addslashes('$Names');
$new_kounta = addslashes('$Kounta');
$conn = mysql_connect("localhost", "root", "")or die("Can't connect");
mysql_select_db("myndb",$conn) or die("Can't select!");
//insert into main client table
$squery = "insert into client(id,Names) values('NULL', '$Names')";
$result = mysql_query($squery, $conn);
//get user id
$user_id = mysql_insert_id($conn);
//insert into clientchild table
$squery = "insert into clientchild values('$Kounta', $user_id)";
$result = mysql_query($squery,$conn);
Inserting into multiple tables
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users