auto_increment in another table

admin

Administrator
Staff member
this is just an example to show what my problem is.

Form variables:
Name
Address
these two fields will be sent to the php-script that has to insert the data into MySQL Tables.

Fields in Table1:
No. (auto_increment)
Name

Fields in Table2:
No.
Address

I want to insert "Name" in "Table1" and "Address" in "Table2".
No problem to make insert into Table1:
Insert into Table1 (Name) Values ("xxx");

But how to insert an address that gets the same "No" like the name.

Thanks in Advance guys, this is really important.

Chris
 
Back
Top