Jump to content

Archived

This topic is now archived and is closed to further replies.

omesa

Inserting into multiple tables

Recommended Posts

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>



Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.