Get next ID number.

[Sleidia]

Good Morning!

Does anyone know if it is possible to retrieve the new
auto-incremented ID number upon creation of a new
record?

More precisely:

My code INSERTS a new record and upload a gif file on the
server at the same time. I am trying to use the new ID number as the file name.
But I can't get this number before or while it is created.

Getting the last record's ID number before adding the new record won't work when records have been deleted previously.

Then, does anyone know the way to "see the future" and get this damned number?

Thanks a lot for your help!

 

[piti]

hi

i think you can use the LAST_INSERT_ID() function or mysql_insert_id() after inserting you data

look here

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1337

for details

 

[Sleidia]

Thank you very very much Piti.

I've been searching through the documentation many times
before but couldn't find this. I wish this documentation
is as well aranged as the PHP one found at php.net.

Have a good day.