Entry

How do I know the last AUTOINCREMENT ID of a inserted record in a ODBC or MSSQL database? (equiv. MySQL_insertid)

Sep 23rd, 2000 19:45
Adrian Kubala, Fernando Moreira,

I don't know about ODBC, but MSSQL has a function, "@@IDENTITY" which
returns the last inserted ID. Use it like so:
$result = mssql_query("SELECT @@IDENTITY AS lastID");
$record = mssql_fetch_array($result);
$lastid = $record["lastID"];