[SOLVED] Can You SELECT the Auto-incremented ID of What You've Just Inserted?

[Fluoresce]

When I insert data into my table, an ID is automatically generated for the new row through auto-incrementation. That's the only thing that is unique to each row.

 

I need to select some of the new data immediately, but I obviously don't know its ID. My question therefore is, is it possible to insert data and select its ID at the same time?

 

[Festy]

Yes it is possible. Use mysql_insert_id() to fetch the recently inserted id.

[Fluoresce]

Thanks, Festy! mysql_insert_id() works beautifully.