INSERT with SELECT in MySQL + PHP?

[McHaxor]

I was wondering what's the most efficient way of inserting something and selecting it's ID property at the same time?For example, I have a table with auto incrementing primary ID column. I insert an item into that table and I need to know the autoincremented ID for use with another table.Right now, what I do is:[*]INSERT INTO table1 the data[*]SELECT FROM table1 the ID[*]INSERT INTO table2 another set of data along with ID.