PHP/mySQL question

Anon

Hello,

I haven't seen this question asked anywhere, hopefully I haven't missed it.

When inserting a new record into a mySQL database, I have an AUTO_INCREMENT field for the id number. Right after I insert this new record, I need to use the id number in a new query, but it was just assigned by mySQL and not by myself, so is there a way to find out what number it assigned? Obviously I could look up the record by some other field, but the fields will be very unique, such as large blobs of text, so that wouldn't be very effective. Please let me know if you can help

Anon

There is a built in mysql function (LAST_INSERT_ID())that will give you the last AUTO_INCREMENT value that was generated in the current session.

Right after you do the insert, querying with
"SELECT LAST_INSERT_ID()" should get you the value.

~Matt

Anon

$result = mysql_query("INSERT INTO foo (bar) values ('$bar') ");
$new_id = mysql_insert_id( $result );

Anon

It would seem to me that it shouldn't matter if you use a field as long as that field is represented by a variable. Besides, I don't believe there is a to do it in one query, but if there is, I hope they come and tell us.

later on,
Morphues