[Resolved] Select last added row. Is it possible?

[jazappi]

Is it possible to select the last added row to a table?

I have a auto increment field, so if I need to I can find the highest number and have it select that I belive. Is there a good way to do that? Select the hightest number in a field?

Thanks for the help.

Joey

[devinemke]

SELECT MAX(id) FROM table

[mtmosier]

A safer way to do it is to get the value from mysql_insert_id immediately after running the insert query in question.

[devinemke]

Originally posted by mtmosier
A safer way to do it is to get the value from mysql_insert_id immediately after running the insert query in question.

...if you want the last row right then and there after the insert, then yes, use mysql_insert_id. if you simply want the last id regardless of when the last insert was, then use my query above.

[jazappi]

does it matter if the insert is on one page and the select is on a seperate?

[devinemke]

if you wish to use [man]mysql_insert_id[/man] you must do so immediately after the call to [man]mysql_query[/man], so no you cannot do the INSERT on one page request and then use [man]mysql_insert_id[/man] on a subsequent page request.

[YappyDog]

Depends on what you want to do with the id, and if more than one person can be doing an insert at the same (or almost same) time.

The query "SELECT MAX(id) FROM table" doesn't guarantee you get the id of the row you just inserted (but that is not what you asked).

[jazappi]

I ended up just using the mysql get id, and passing the varible from page to page. THanks for the info.

Joey