Is it possible for mysql_query("INSERT INTO.....") to return the values in the record it inserted? For example, lets say I have a table "table1" with primary key "id" and column "col1", can I do the following:
$result=mysql_query("INSERT INTO table1 VALUES(null,'value')");
then retrieve the value of the primary key for the row it has just inserted? I don't want to use a SELECT statement to retrieve the row as it may be possible for another user to enter the same value on a different row.