Primary key is set to auto increment, after inserting new row... how to get it?

[inktri]

What's the most efficient way to accomplish the following problem:

 

I have a table called: dogs

Attributes: did (primary key, auto increment), name

 

if I run this query within PHP:

INSERT INTO dogs (name) VALUES ("bob")

 

How can I echo the "did" of the newly inserted dog?

 

Thanks for the help!

 

[leonglass]

I think this may be what you are after