[Resolved] find mysql autoincrement after insert

[section31]

Hi, i was wondering if there was a function or something in php where i can find out what the next autoincrement field is after I insert a row into my msyql table. Or would I have to do another query... I'm trying to do it in one query, but I don't think its possible.

[section31]

ah...i found a mysql function to use...

last_insert_id();

Thanks anyway.

delete thread?

[tsinka]

Hi,

you can mark the thread resolved. There is a link just below my post.

Besides that, there is a PHP function called mysql_insert_id().

Thomas