Getting Id of new record

[elitegoodguy]

I have created a form that sends information to two different databases. In my script to add stuff to the databases I have it connecting to 1 table first to create an entry. Then connect to another Table to send more associated information.

With this second table I need to send the Id # of the record that was just created.

How do I get the Id number of that record since it is NULL and Mysql is set to auto increment?

[NogDog]

mysql_insert_id()

[elitegoodguy]

NogDog wrote:

mysql_insert_id()

Thank you that worked perfectly.

[Tezread]

I have used this in a form before to select the last inserted id:

$sql ="select LAST_INSERT_ID() as id from tablename";