how to select last autoincrement id using php and mysql

Question

Possible Duplicate:
php/MySQL insert row then get 'id'

I have an inset command such as

insert (name) values($name);

I have id column as autoincrement. How can I get the id of the inserted record after inserting.

Answer 1

insert (name) values($name);
SET @lastid = LAST_INSERT_ID();
select blah_blah from table where id = @lastid;

To get that back into php, you do a normal mysql select on it like this:

select @lastid;

Answer 2

For mysql you can use mysql_insert_id to get the id of the last inserted row.