Re: How do I get the row id of the last insert?

[Rudy Lippan]

On Wed, 12 Nov 2003, Dan Anderson wrote:

> If I insert a row into mySQL with an indexed auto incrementing column,
> id, how do I get the id of the last inserted row?
> 

For right now, you do this:

 $insertid = $dbh->{'mysql_insertid'};

However, In the next version of DBD::mysql you will be able to use
standard DBI function last_insert_id().

Rudy