php - mysql_insert_id returning odd numbers? -


i know it's depreciated, , not practice. command: mysql_insert_id reason returning weird number. , never has done before.

i cannot find reference number anywhere. instance, inserted record id:2, , gives me number 1587.

where getting from?

i've had resort reverse-querying database exact values i've pulled out of id. makes no sense.

edit sorry if didnt explain this; standard insert statement:

insert `job` (`subject`,`deadline`,`status`) values ('$title','3454354','created'); 

and autoincrement on pk called 'id'.

the field id results in being set 2, mysql_insert_id returns odd number. ran table status , shows auto_increment expected. not inserting else in time. literraly straight after insert querying last inserted id.

the manual says mysql_insert_id returns:

the id generated auto_increment column previous query on success, 0 if previous query not generate auto_increment value, or false if no mysql connection established.

do have auto increment on?


Comments