[asherkin]

Originally Posted by generalmemer Just bumped here and since he didn't mind to let us all know his solution 12 years ago, it's that you have to call SQL_GetInsertId() in the query callback using the main database connection handle and take it from there. Because the query doesn't execute instantly, we have to wait for the callback. Otherwise it'll return 0. Nothing is wrong with the function.

This 12 year old thread far predates threaded SQL support - there was no callback involved in the original code.