I have an online poker game, where this one function represents a whole poker table. And there are many instances of this function running at the same time, right now there are about 24 tables (24 functions). The problems is, that the queries are different for each function, depending on the poker table's ID.
I have a table in MySQL, in which each row holds information about one poker table. The queries these functions execute retrieve information from these rows.
My thoughts are that there will be only one result set (the last one)... If I'm right, then what can I do, to work around this problem? Of course I can do a loop that checks if a query is being executed and when it is not, then continue with the function, but that seems like a bit too complicated.