[thelist] Sql muti table insert needing auto increment value

[fstorr]

Hi all

I need to do a SQL insert statement into three tables.  However, the
second table contains a column which is a foreign key to the first
table's auto incrementing index.  How do I insert this value into the
second table (I'm using PHP+MySQL) when I don't actually know what it
is?

Regards

Francis