BizID column must be set as AUTO INCREMENT. After an INSERT query, there is a function called cache_insert_id which retrieves the value generated by AI column.
Your code executes a non-threaded query and you will need to free the memory if you are going to retrieve:
pawn Код:
new Cache: cache_id = mysql_query(Database, query);
bInfo[id][BizID] = cache_insert_id();
cache_delete(cache_id);
to avoid memory leak.
Why do you not use threaded queries? It is advised to, most of the times.
pawn Код:
mysql_tquery(Database, query, "OnBusinessCreate", "d", id);
// pass `playerid` if you send message to the creator of the business
pawn Код:
forward OnBusinessCreate(business_id);
public OnBusinessCreate(business_id)
{
bInfo[business_id][BizID] = cache_insert_id();
}
