my question :

i want to distinguish that this value is for which team (t1 or t2), and it's id will be inserted in table which table (yellow for yellow cards table and g for goals table).

how to distribute varibale name to know for which table and team is this variable ??.


example:

i have a from for world cup players.
the variables are created automatically using mysql.
this is one of my variables:
$t1_yellow_1 = 24;
this variable means that
t1 --> team number one
yellow --> this player took a yellow card in this match
1 --> counter
24 --> id of player



another example
$t2_g_7_2=4;
$t2 --> team 2
g --> this player scored goal(s) in this match
7 --> id of player
2--> counter
4 --> number of goals scored by this player

The humanity created arrays for such things.
MySQL generates query result only (not variables). The other code may process query result to a variables. Exactly this code must prepare proper information in arrays view:

$player['team']='t1';
$player['yellow']='yes';
$player['counter']=1;
$player['id']=24;