Get SQL ID

I have a table where I'm auto incrementing as data is inserted. I was wondering how I would obtain that ID to add data into another table at the same time where I want to use that ID?

 

INSERT INTO Table 1 id = '' //auto increment

$last_insert_id = mysql_insert_id();

INSERT INTO Table 2 id = $last_insert_id

 

Thanks Johan.

You're not just a pretty face after all

 

Thanks Braveheart.

Have you heard of this thing called Google?

 

I like helping out DP though. I figure that if I go to DP first then not only will I get my answer straight away but I set up all the keywords for newbies like myself trying to figure these problems out.