Using PHP / MySql...
I have a transaction table and a record is automatically inserted when someone Initiates a transaction, and then is updated later in the process, based on the recID.
I want / need to keep the recIDs filled with completed transactions without any skips in the ID sequence (as created by the auto increment on insert)
If someone Voids a transaction without completing it, the record status is set to ‘V’ so it can be reused for the next transaction.
How can I get the recID of a transaction returned to my after doing an UPDATE to the record?
I can’t seem to find a way to do it, unless I do a manual QUERY for the recID after the UPDATE searching on unique data that was updated.
Is this the only way to accomplish this task or is there a built in function that would return the recID?
Thanks in advance for your feedback.