mysql_insert_id()

[jkkenzie]

The command below works BUT when i delete ALL data from my database say from my autoincrement primary key field "id" 1to 20,  the next inserted field "id" value would be 21, BUT the command below gets 0 instead of 21.

 

I need this code to pick the "id" value used to store the record.

                                                                                       

$mysqlval= mysql_insert_id();

 

Thanks

Joseph

[PFMaBiSmAd]

mysql_insert_id() only works when used immediately after an INSERT query and you would need to tell us how you are deleting all the data from your database.

[jkkenzie]

i use phpmyadmin to delete my test data from my database