Insert new data to tables(after normal)

[umnik]

Hi,
I have a database(Mysql), consists of 4 tables(users,adress_book,etc). In table user i have Id keys linked to adress_book. So, in case i want to insert a new user i need to update more then 2 tables(no problem), and (here i have my bottleneck) give to id keys in both tables the same number - i have made it but my script looks very ugly and big. Can anyone put me to some materials(articles)with descriptions of successfull techniques?
Thx,
Andriy U

[mattw]

Well, if you are using auto increment in the first table you insert into, I would look into the mysql_insert_id() function. Then you have your id to insert into the other tables...

Matt Wade
codewalkers.com