Having problems inserting data into 2 linked tables from same form

[slaterino]

Hi,

I have 2 tables which need to be updated from the same form. I created 2 Insert Into queries to insert the data from the form into the tables, but have one massive problem. As the 2 tables need to be linked, I need the auto ID from the first table to be present in the second table. This id would not be created until after the queries have been run, so how would I go about getting this inserted into the second table? Does anyone have any suggestions?

 

Thanks

Russ

[rhodesa]

After your first INSERT, use mysql_insert_id() to get the auto_increment id. Then use that in the second INSERT

[slaterino]

Thanks! I'll give it a try in a minute.