mysql_insert_id(); / last_insert_id(); isn't returning latest ID without any known issue

Asked Jun 06 '14 at 06:43

Active Jun 06 '14 at 06:43

Viewed 125 times

mysql_insert_id(); / last_insert_id(); isn't returning latest ID without any known issue

$insert = "INSERT into `table` (`name`,`address`) VALUES ('$name', '$address')";                    mysql_select_db($database_A, $A);
$result = mysql_query($insert,$A) or die mysql_error();
$latest_id = mysql_insert_id($A); 
var_dump($latest_id);

According to PHP manual I see any reason in the code why it's not returning the latest ID, instead it's always returning NULL or 0. It's happening in case of last_insert_id(); too.

This function returns 0 if the previous operation does not generate an AUTO_INCREMENT ID, or FALSE on MySQL connection failure.

Any idea?

asked Jun 06 '14 at 06:43

Silent Galaxy

1

And data is inserted fine? – Hanky Panky Jun 06 '14 at 06:47
2

Why do you people still using deprecated API? Just read the first sentence of http://us2.php.net/manual/en/intro.mysql.php Also take a look at this http://stackoverflow.com/tags/mysql/info – ElmoVanKielmo Jun 06 '14 at 06:49
try http://stackoverflow.com/questions/8243503/mysql-insert-id-returns-0 – Rakesh Sharma Jun 06 '14 at 06:51
2

try mysql_insert_id() without the connection variable $A it actually uses the last opened connection if connection is not specified so anyways $A is redundant. – user1613360 Jun 06 '14 at 06:53
Please check if your table schema has an auto_increment() id field. – user1613360 Jun 06 '14 at 06:54
@ Hanky 웃 Panky, yes data are inserted properly along with auto_incremented id. – Silent Galaxy Jun 06 '14 at 07:02

mysql_insert_id(); / last_insert_id(); isn't returning latest ID without any known issue

0 Answers0