fuction last_insert_id

24Charly

Does somebody have a script for me where the fuction last_insert_id is in and working.

Thanks

PHPdev

do you mean mysql_insert_id()???

24Charly

No it must be LAST_INSERT_ID this function will give the last inserted id from the auto_increment column.
I found this function in a book tried everything but it does not want to work.

LAST_INSERT_ID()
RETURNS: int

Is there an other way to get the last insert of a table?

Thanks

leatherback

Hi,

Check the MySQL manual (weblink below) and this should work:

INSERT INTO foo (auto,text) VALUES(NULL,'text');
SELECT LAST_INSERT_ID();

http://www.mysql.com/doc/en/ODBC_and_last_insert_id.html

And of course: You can do something like:

"select * from table order by ID desc limit 1"

24Charly

Thanks for the information.
The first solution is what I was looking for
The second solution, I am not proud that I could not find this verry simpel solution my self. This approch to the matter slipped my mind completely.

Thank you verry much (please do not mind the spelling)

Lars_Berg

Don't use the second solution. There is no warrant that the highest id is the one that was generated for your insert.

jonsof

So,is there any way else that something can be inserted into the database?
Could you give me an example because i cannot think of an occasion like this.

But if you mean an fuction that insert automatically values to database then everything it's all right!

Lars_Berg

.
Multithreading,

User a inserts into database
user b inserts into database
user a retrieves highest id value i.e. the on that was generated for b

Mysql may in some cases reuse an id for a record that have been deleted.

sem_db

Warning:

mysql_insert_id() does not work for a field that is bigint

please see the mysql_insert_id() function in php.net