I have accounting data in SQL. These are entries made for a sale so for every sale made there is an offsetting entry for cost of goods sold as well. In the accounting system we use, it auto generates a transaction id in the TxnId column only for the sales lines not for the cost of goods sold lines for
Tag: uniqueidentifier
PHP Return ID[uniqueidentifier] after sql INSERT
Like the title says, I want the id of a row to be returned after INSERT to the database. I’ve got 2 functions, one to make a connection to the database: And one to insert a new record: I need the last function to return the ID of the inserted row, how should I do this? EDIT: Like the title