Database- unique Identifier

[Bes]

Hi

I have a field in a DB I am making which is 'EntyID'- it's an auto- incremented number. When I make a submission to my database, is there an easy way I can get the unique identifier back so I can use it? i.e. something like.... "Submission accepted. Unique ID is <xx>" At the moment I have to do a select statement which in theory could give me more than one result.

I am using PHP and MySQL

Thanks

 

[ChrisB]

As long as the script is using the same sql connection as the one which performed the insert you can do:

mysql_query(YOUR_INSERT_QUERY);
$the_last_id = mysql_insert_id();

http://uk3.php.net/mysql_insert_id

 

[Bes]

Ah great, thanks!