[PHP-DB] Re: mssql: insert a record and return the auto increment ID

than one query in the mssql_query() function. I get error like: Attempt to initiate a new SQL Server operation with results pending on the next query() call. Heiko Heiko Mundle [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I insert a new record

[PHP-DB] mssql: insert a record and return the auto increment ID

I insert a new record with PHP into my MS SQL Server database. The key is defined with auto_idINT IDENTITY(1000,1) NOT NULL, how do I get the new id to use it in PHP? To insert the record I use this code: $sSql = INSERT INTO myTable (time_in ) VALUES (

[PHP-DB] error handling with ms sql server (mssql) - insert and update unique indexes

sorry for posting this mail twice, but the first one doesn't appear on the news server (posting with google, doesn't work...) Hi, when I insert a new record with a unique indexed attribute, which is already in the table, I only get some php warnings: Warning: MS SQL message: Cannot insert