Insert to two tables via PHP

[holsum]

I have data that needs to be inserted into two mysql tables via php and I am running into problems doing so:

 

Table1

 

user_id, user_name

 

Table2

 

user_id, user_email

 

in PHP I have something like this:

 

$query = "insert into Table1 set user_id = '$id', user_name = '$username'";

$result = mysql_query($query);
if (!$result) {
  die('Invalid query: ' . mysql_error());
}

// second query
$query2 =  "INSERT INTO Table2.user_id FROM Table1.user_id set user_email = '$email'"; 
$result2 = mysql_query($query2);
if (!$result2) {
  die('Invalid query2: ' . mysql_error());
}

 

I am getting an error "Invalid query: Duplicate entry '0' for key 1"

 

What am I doing wrong?

 

-holsum

[rajivgonsalves]

I don't know if this insert syntax is correct but I mostly use

 

 

insert into tablename (fields) values (values)

 

[holsum]

But that would not solve my issue with the two queries?

 

-Holsum

[rajivgonsalves]

I mean in the second insert could be

 

INSERT INTO Table2 (userid,user_email) values ((select userid from Table1 where email='$email'), '$email')

 

not too sure it will work but you can give it a try

[fenway]

This will work:

INSERT INTO Table2 (userid,user_email) select userid, email from Table1 where email='$email'