MYSQL Auto-Increment Help

[Judahnator]

I am writing a program that will insert data into a database.

 

Each row has an auto increment ID as the index, but i need to grab that as im putting the data in.

For example, I have data like this:

 

 

When I am inserting data, i need to know the ID that row will be so i can concat "This Table is ID " and the row number.

 

How could I accomplish this?

[amp88]

This might help: How to Get the Unique ID for the Last Inserted Row.

[MatthewEnderle]

I agree with amp88. I would suggest that getting the last row would be the best method. Now I would make sure that you run it before you call the function to run the transaction.

[Judahnator]

That works. Thanks a ton!