Inserting data from a form into two tables

[ainoy31]

Hello-

 

I am trying to get the logic in inserting data from a registration form into two tables in mysql database.  One table (name) has a primary key (name_id) and the other (address) has a primary (addr_id) and foreign key (name_id).  Inserting into the tables is not a problem but I want to make sure that if I reference to the name and address table, it will retrieve the probably address with the name.  Do I have to first insert into the name table and then get what the name_id is?  Next, insert that name_id into the address table along with the rest of the info?  I hope this is clear enough.  Much appreciation.

 

thx.

 

AM

[Nhoj]

You could do something like:

 

mysql_query('INSERT INTO `users` VALUES (NULL, "NAME")');
$name_id = mysql_insert_id();
mysql_query('INSERT INTO `addresses` VALUES (NULL, '.$name_id.', "'.$address.'")');

 

Edit: The NULL values represent the columns that would probably be auto-incremented...

[ainoy31]

I see what you are suggesting.  One thing though, I am trying to understand this statement: $name_id = mysql_insert_id();

 

[ainoy31]

thanks for the help. 

[MrSheen]

I see what you are suggesting.  One thing though, I am trying to understand this statement: $name_id = mysql_insert_id();

 

 

I think it gets the ID of the last inserted row.

[ainoy31]

Yeah.  All is working good.