Insert into two tables..??????

[Anon]

I have two tables, one for userinformation (users) and one for info about someting else (othertable). When I first insert into the user tabel, I want to have the UserID that the given person get, because in the other table I need to insert the same UserID so that they refer to eachother. Could someone explain this in details..?

[Anon]

by the way..am using a mySQL database and php... 🙂

[[deleted]]

I assume you are using an auto_increment field for the userid?

Then do you query to insert the record into the first table, use mysql_insert_id to get the userid.
Then you can use that id to insert into the second table (which should ofcourse not be an auto_increment column)

[Anon]

Yes, I am using a auto_increment field for userid.

My first query:
$sql = "insert into Users(FirstName,LastName,Email,PostNr,PostSted,Phone,Mobile,UserName,Password)
values ('FirstName','LastName','Email','PostNr','PostSted','Phone','Mobile','UserName','Password')";

My second:
$userid = mysql_insert_id($userid);
is this wrong..? how do I set the userID..? and in the query..? is it the correct way to set in the userID?

$sql = "insert into FlightInfo(UserID,PilotID,FlightNr,Aircraft,DepFrom,DepTime,ArrTo,ArrTime,FlightTime)
values ('$UserID','PilotID','FlightNr','Aircraft','DepFrom','DepTime','ArrTo','ArrTime','FlightTime')";

[Anon]

Hi Griffith,

This is exactly what I have been trying to do for the past day. Have a look at my post below 'Insert auto_increment to multiple tables' hopefully it should explain a bit.
I tried using the following code but it didn't work.

function updatetable2() {
$sql="INSERT INTO table2 (user_id) ".
"VALUES (LAST_INSERT_ID())";
}

If you do get this to work, can you let me know, either post here, or maybe mail me direct.
Cheers
Ben

[[deleted]]

allmost correct.

mysql_insert_id() takes the database-link-identifier, not the name of a field.