Grabbing the auto_increment field number for a row of data which has just been added.

[mark_h_uk]

Hi,

I have got a form setup which sends some data such as name, year, colour etc into a database (mysql) which has an auto_increment field in the database. What i want to do is on sending the data to the databse, i want to grab the auto_increment number for that row of data that i just sent.

Would any be so kind and tell me how to do this because its got me stuck.

Many thanks,

Mark

[jburfield]

SELECT last_insert_id();

That will give you the value of the last inserted auto_increment field.

-- Jason

[mark_h_uk]

thanks jburfield i'll give it a go...

[mark_h_uk]

Yep got it working thanks for your help!

[superwormy]

If you just want to grab the Last Inserted ID, you don't even need to run a select query like jburfield said, you can just do this after the query:

$last_inserted_id = last_insert_id();