php中的mysql_insert_id（），不返回最后一个插入ID？

Question

This is my Mysql Query. In my table Id is Auto-Increment type.

$sql ="INSERT INTO product_detail (master_detail_id,Product_code,Product_label) 
values
('8330','TOTAL','products'),('8330','010290','demo'),('8330','010639','Live demo'),
('8330','020900','demo fat'),('8330','030344','demos')";

 $insertDetails = mysql_query( $sql);
echo "last insert id-->".mysql_insert_id();

I am getting last insert id--->1 but I should get it 5. I don't know why it is happening?

table structure

     id            bigint(250)  No  None    AUTO_INCREMENT  
Product_code       varchar(20)  latin1_swedish_ci       No  
Product_label      varchar(500) latin1_swedish_ci       No  
master_detail_id   bigint(250)          No  None    

Answer 1

mysql_insert_id() will return id if you specified id column as AUTO_INCREMENT. You should be aware that if your id column is BIGINT type result which function returns might be wrong (this is also specified in php docs: http://php.net/manual/en/function.mysql-insert-id.php)