[RESOLVED] Get the PK of a auto increment value you just inserted

[Zeratulsdomain]

right now my program inserts a new record and a PK of int is automatically created. But I also need a second query to insert data into another table that has a 1:1 relationship.

Is it possible to somehow get the auto increment value that was created from my insert statement? Or should I simple do another select query to get the latest entry inserted?

I guess for now ill use

SELECT max(ID) FROM tableName