How to get current ID when inserting in mySQL

Databases
1

I created a table with columns ID, Message and Author. ID is int, primary key, unique for each entry. Now when I add new entry into database i would like to know what ID was assigned to it. How can that be done?

Using SELECT ID from… WHERE Author LIKE … AND Message LIKE …
is not OK because there can be 2 entries with the same content, so I would get wrong ID.

Any ideas ?

2

mysql_insert_id() will do the job!

mysql_insert_id – Get the id generated from the previous INSERT operation

http://www.php.net/manual/en/function.mysql-insert-id.php

I use it like this after a submit:
$new_id_number = mysql_insert_id();

tada!

3

it worked :smiley:

thanx

4

Sure… glad it worked!