get id of newly inserted

[frans-jan]

Hi,

Is it possible to get the ID (auto increment) when you insert a row in a table (using php....)

I mean without a select query afterwards, I need this because the ID is possible the only unique cell in a row.

Thank you

[Anon]

$sql = "INSERT INTO mytable (this,and,that)";
$link_id = mysql_connect($DBhost,$DBuser,$DBpass);
@mysql_select_db("$DBName");
$results = mysql_query($sql);
$id = mysql_insert_id($link_id);
mysql_close($link_id);

NOTE: $id = mysql_insert_id($link_id);

this will assign the autoincremented ID# to $id.

-dr

[gerardg]

rtfm();

[frans-jan]

It's right there in the manual...

mysql_insert_id()

Thank you all you folks!