Your question, your audience. Choose who sees your identity—and your question—with question security.
if this can be done only via php/mysql combined - how would this be achieved?
// update test transactions table $sql10 = "INSERT INTO dwtphovu_8347379386_test.8_transactions ( bigint_TransactionID, text_TransactionEvent, bigint_SupplierID, bigint_LeadID, bigint_TransactionAmount, bigint_TransactionBalance, timestamp_TransactionEvent, smallint_LeadOrdinal ) SELECT PTR.bigint_TransactionID, PTR.text_TransactionEvent, PTR.bigint_SupplierID, PTR.bigint_LeadID, PTR.bigint_TransactionAmount, PTR.bigint_TransactionBalance, PTR.timestamp_TransactionEvent, #insert integers counting from 0 here, per lead id. FROM dwtphovu_8347379386_prod.8_transactions PTR;"; $result10 = mysql_query_errors($sql10, $conn , __FILE__ , __LINE__ , true );