> >From looking on the web (MSDN) I found the @@identity and the explanation > of > what it is, but MS's "example" is horrible and does not show a good > context > for using this function. Could you elaborate more on its use? $q = mssql_query("INSERT INTO TableName(...) VALUES(...) SELECT LAST_INSERT_ID=@@IDENTITY"); $r = mssql_fetch_assoc($q); HTH, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php