Return a MySQL value on Insert

[dan400007]

Hi, I want to insert a record into a mysql table and then have it return ID for the record just entered.  Example of what I want to happen is below:

table:
ID mediumint( 8 ) Auto-increment unsigned not null
col1 text
col2 text

INSERT INTO table (col1, col2) VALUES ('This is col1', 'This is col2');

When the insert occurs I want mysql to return the ID for the record it just inserted, is this possible?

Thanks, Dan

[trq]

Funnilly enough there is a function made especially for that. [url=http://php.net/mysql_insert_id]mysql_insert_id[/url].

[dan400007]

Brilliant!!  :D

Thanks for such a quick reply.

Dan.