Newbie question: inserting into 2 dbs

[Anon]

Hi folks,

I have to insert a new record into a table set. I have one table with several fields and a primary key (called id). In my other table I have the id key as well and several fields. What I can't get my head around is when I insert a new record into the first table, the id is auto-incremented by mysql, but how do I obtain that value to assign to my secondary table with the key id as well?

Perhaps I've designed my database wrong...any assistance would be appreciated (new to php/mysql but not new to programming)

Kent

[Anon]

$last_id = mysql_insert_id();