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
Post a Comment