mssql_insert_id?

[Anon]

Hi.

Got a new server with W2k installed on it. Can\'t change that but are still going with PHP (not switching to ASP). The database we got license for on that server is msSQL. What I seek is a good way to do what the mysql_insert_id does with mySQL but for the msSQL database. I couldn\'t find a similar function for msSQL.

/Martin

[Anon]

hi,
well, mysql_insert_id() is of course only for mySQL. But i guess you can do this like:

insert the record
'if' the columns have the auto_increment field, then right after inserting get the MAX value which will be the latest inserted ID.

i know its not as efficient as insert_id() method, and can give problems if LOTS of users are using the system, and it happens that someone inserted record within same second.

🙂