How to INSERT and then UPDATE?

[zzz]

I am creating a record by submitting data from a form by doing usual

INSERT INTO myTbl_1 (item) VALUES ('$newItem')

When a record is created a unique ID is assigned to that row.

Now I also need to update myTbl_2 with that new Unique ID that was assigned to the new line entry.

It am trying to accomplish it without adding extra steps, like clicking additional buttons.

Any suggestions?

[devinemke]

are you using mySQL? if so then use [man]mysql_insert_id[/man].

[zzz]

WOW!

I thought it could be simpler then inserting then opennning connection and extracting and then updating etc.

This is PERFECT!