Jump to content


Photo

Inserting into multiple tables


  • Please log in to reply
1 reply to this topic

#1 omesa

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

<html>
<head>
<title>insert</title>
</head>
<body>
<?php

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


if(isset($id))
{
  //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);

}

?>
</body>
</html>





#2 printf

printf
  • Staff Alumni
  • Advanced Member
  • 889 posts

Posted 29 September 2006 - 03:06 PM

Where is $id, being set?

me!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users