lastInsertId() always returns ZERO

[jrahma]

Hi,

I am trying to get the lastInsertId() in PDO but always getting it as ZERO. where is the problem?! here is my code:

	$mysql_query = $mysql_connection->prepare($mysql_command);
        // $mysql_connection->beginTransaction();
	$mysql_query->bindParam(':param_member_email', $member_email, PDO::PARAM_STR);
	$mysql_query->bindParam(':param_member_first_name', $member_first_name, PDO::PARAM_STR);
	$mysql_query->bindParam(':param_member_last_name', $member_last_name, PDO::PARAM_STR);
	$mysql_query->bindParam(':param_member_password', $member_password, PDO::PARAM_STR);

$mysql_query->execute();

    $member_gallery_folder = "gallery/" . $mysql_connection->lastInsertId();

[jrahma]

I tried this and not getting any error. I am getting Your Membership id = 0 instead. Record was added successfully to the table but why I am getting zero?!

if($mysql_query->execute()){
$mem_id=$mysql_connection->lastInsertId(); 
echo " Thanks .. Your Membership id = $mem_id ";
}
else{
echo " Not able to add data please contact Admin ";
print_r($mysql_query->errorInfo()); 
}

[dalecosp]

Does the table have a PRIMARY key that is set to auto_increment?

[dalecosp]

See also the user note here.

[jrahma]

dalecosp;11032615 wrote:

Does the table have a PRIMARY key that is set to auto_increment?

Yes. member_id is an int field, Primary - auto Increament

and I am getting it populated with an auto number every time I run the code and check inside the table

[johanafm]

And did you also?

dalecosp;11032617 wrote:

See also the user note here.

[jrahma]

johanafm;11032633 wrote:

And did you also?

yes I did but still ZERO