how do I find the row I just inserted?

[cleromancer]

I've been using MySQL and have been using the mysql_insert_id() function to determine the id of the row just inserted (auto increment of id column).. but now I am using pear I don't know what to do.

$result->affectedRows() -- returns the number of rows affected not the affected rows..

Any ideas?

Michael.

[Lars_Berg]

Use the following query

select last_insert_id()