[RESOLVED] Retrieving last inserted record

[JoeBrewer]

Hi

I am trying to retrieve the primary key of the last record that I insert using mysql. Is there any way of doing this?

Thanks,
Joe

[devinemke]

use the MAX() aggregate function

[goldlikesnow]

$lastPrimaryKey = mysql_insert_id();

[JoeBrewer]

Excellent, exactly what I wanted. Thanks very much.

Joe