Knowing value of auto increment

[zebedee]

If i am updating a table in a db (via a web form) that uses auto increment for the primary key, is there any way of knowing what the value of this pk has been set to. I need to know the value of it as it will be a foreign key in another table and was wondering if there was a way to do it rather than query the db with the values just entered into the form. I just thought there might be a more efficient way of doing it !!

Cheers

[hand]

If you are updating an existing "record" the primary key is not altered automatically (and shouldn't !).
If you are inserting a new "record" you can use
mysql_insert_id() to get the ID generated from the previous INSERT operation
http://www.php3.de/manual/en/function.mysql-insert-id.php