This may be a bad structure. Let me know if it is, it's been a long time since I did any database design.
I have a
tblGame in a mySQL database, which has two fields:
In the actual game, multiple players will sit on the one table. So I have both fields set as a combined primary key. And
ID_Table is set to auto-increment.
ID_Player is an auto-increment in another table (
tblPlayers). What I'd like to do is to get the
ID_Table value before any players are added to the table. The actual game analogy is to an open table (with
ID_Table already assigned) sitting there waiting for players to join. As they join, they get added to
Is it possible to do this?