[newbie] Get ID from previous INSERT?

[John Doe]

Hello,

This is a newbie SQL question.

I need to add a new record into two tables, where the second table requires the ID set in the first time.

Is there a SELECT I could use to get it?

Pseudo-code:
==============
INSERT INTO table1 (somecol) VALUES ('blah');
??? SELECT set ID=LASTROWID(table1);
INSERT INTO table2 (table1_id,someothercol) VALUES (ID,'blah2');
==============

If need be, I can turn off the Php application that uses MySQL so that no user makes changes to it.

Thank you.