autoincrement insert

I have a question regarding an autoincrement insert, I would like to pull the new number that is inserted into the table immediately after the insert. Is there a way to get the number that was inserted without having to run a select to find this out. I know it is stored in the database but I cant find a function in PHP that will pull this information.

The function for PHP you need is:

$lastInsertedID = mysql_insert_id();

This will give you the last inserted auto-incremented ID.

Peter