Getting ID of record as it is created

[redneck]

Is there an easy way to return the ID of a new record as it is created?

I'm INSERTing a new record in a table, and once that is completed I have to INSERT more records in another table using the ID of the new record I just created in the first table. Is there an elegant way to get the auto-incremented ID of the first record as I enter it, or do I have to kludge something together by using the ID of the last record entered?

[ultraslacker]

http://www.php.net/manual/en/function.mysql-insert-id.php

[redneck]

Brilliant, ta.