How to access primary key, from last insert.

[dwessell]

Hi all..

I'm making a series of inserts into a MySQL DB.. The inserts occur across a few different tables..

For example, I make an insert into a table called 'UserInformation'. UserInformation has a Primary Key that auto increments. So when I insert the other colums into that table, the primary key will be generated for me.

After I have made the insert into that table, how can I find out what the Primary Key (In my case UID) was that was assigned?

Thanks
David

 

[dwessell]

Found it, mysql_insert_id ...