[SOLVED] php get the auto incement value at the time of insert

[jonniejoejonson]

I want to insert 'message' details into a table that has an autoincrement int. This integer servers as the unique index for the message. However I need to select this index number as it is inserted so that I can store it in another table... do you know how to do this...

 

$sql= "INSERT INTO messages (date,subject,message) VALUES

(NOW(),'$subject','$message')

 

I then want to select the 'messageindex' for this inserted row";

 

(messageindex is the autoincrement integer)

 

thanks to any responders.

 

 

 

 

[p2grace]

$id = mysql_insert_id();

[The Little Guy]

$id = mysql_insert_id();

 

OMG that will be very helpful for me!

[jonniejoejonson]

Thanks alot p2grace, that works perfect.