storing auto increment value as it is inserted?

Hi there.

Is it possible to store the value of an auto_increment value as a PHP variable (in my case event_id) as a record is created using the INSERT method?

What i'm trying to do is let the user insert at event, and then immediately display - 'view your event here example.com/event.php?id=[the event id] ' .

All I can think of is doing a SELECT event_id where eventname = whatever, but there must be an easier way?

many thanks.
Patrick.

http://dev.mysql.com/doc//refman/5.0/en/information-functions.html#function_last-insert-id

After doing the INSERT, simply then do SELECT last_insert_id() *ON THE SAME CONNECTION*. Don't close or otherwise break the connection and you'll get the right value.

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

perfect, thank you.