Hi all:
I'm building a database system where I have a table that has one field that is auto_increment and a bunch of other text fields. That auto increment field is my unique id column. when I insert a new record, I want to return the unique id generated by the auto increment field.
Here's the problem. When I insert a new record, auto increment field assigns, for example, the number 5 as my value for that field. However, mysql_insert_id returns 51 when called immediately after the insert. I thought it would return 5? I'm the only one working on the system. Any ideas?
