How to obtain automatically generated id

[mysql]

I want to write a php script that creates a new row in a table with an auto increment field and then creates additional records in other tables where the automatically generated field has to be used.

Is there a way to get the automatically generated number as a result of an Insert query so that I can then use it in the next queries?

Thank you