[SOLVED] Fetch auto-incremented index ID while the row is being created

[Errant_Shadow]

I've been having a hard time finding this because I'm not sure how to ask it succinctly.

 

Basically, I'm entering new data rows into a database, but I then need to retrieve the auto-incremented primary key for use immediately after. I can't know what the key will be before I create the row (that I'm aware of), so I was wondering if there was anything I could do to retrieve that value without creating and running a separate query.

[corbin]

You could probably get by with mysql_insert_id.

 

Depending on what you're doing, you might should read the "Caution" in the Notes section.

[Errant_Shadow]

Ah, that's awesome. No, none of my tables are BIGINT sized so there shouldn't be a problem.

 

Thank you very much

[Errant_Shadow]

as a note: mysql_insert_id() MUST be called immediately after the insert query, even if the only other query run was not an insert. It will return 0 otherwise, rather than the insert id.