Get SQL ID

[Weirfire]

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?

[T0PS3O]

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

$last_insert_id = mysql_insert_id();

INSERT INTO Table 2 id = $last_insert_id

[Weirfire]

Thanks Johan. :)

You're not just a pretty face after all :p

[T0PS3O]

:D Thanks Braveheart.

Have you heard of this thing called Google (http://www.google.co.uk/search?hl=en&q=mysql+last+insert+id&btnG=Search&meta=)? ;)

[Weirfire]

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.