Current auto_increment value from MySQL?

[irbrian]

Is there a way to return the current auto_increment value after an "INSERT" operation from MySQL without another SELECT query? I'm searching MySQL.Com and haven't found anything yet, so it doesn't seem likely. I realize this is more of an SQL question, but maybe there's a PHP function that would give me this information..? It sure would save me a lot of frustration.

[Mordecai]

mysql_insert_id() may give you the needed info.

[irbrian]

Precisely what I was searching for, turns out I had seen that before 😉 thanks for the assistance.

[irbrian]

For some reason, mysql_insert_id() keeps returning null. Any thoughts??

[irbrian]

My mistake, I was incorrectly using the query link identifier in the parameter list instead of the DB resource identifier.