Jump to content


Inserting into multiple tables

  • Please log in to reply
1 reply to this topic

#1 omesa

  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 29 September 2006 - 03:00 PM

Hello guys,
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


global $Names,$Kounta;

$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);



#2 printf

  • Staff Alumni
  • Advanced Member
  • 889 posts

Posted 29 September 2006 - 03:06 PM

Where is $id, being set?


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users