PDO lastInsertId does not work on transactions?

user_143030 0
Viewed 10725

I am using PDO for the first time with MySQL, just playing with it at the moment.

So far when I try to do an insert wrapped in transactions... 

$this->dbh->beginTransaction();
// $sql query ran
$this->dbh->commit();

echo $this->dbh->lastInsertId();

lastInsertId() is returning 0...when I run the same query outside of a transaction, I get the proper id number returned. Is there something I am missing here?

pdo mysql php
1 Answers
Related