When inserting into MySql can you return values?

[jtown]

Say I have a column (called ID) that auto increments in my DB and I do this:

$sql = "INSERT INTO parts (partnum1) VALUES ('$partnum1')";
$result = mysql_query($sql);

Is there a way to return the ID that was created? I could search for the max ID in my database, but there's a small %age of error involved with that (if something else writes to the db right before that command executes).

TIA.

[harlowhair]

use the command

$currid = mysql_insert_id();

mysql_insert_id() returns the id of the last insertion

[jtown]

that should do it.

thanks!