inserting same data into multiple tables that are selected from a list

[FatRat]

i have used a form to create a list of checkboxes.

eachbox has the name=players[] and value=$id

$id is the id of the player, this list was created by an SQL query, so the list contains all the playernames and the checkbox has the corresponding value.

When I hit the submit button I would like to Insert data into each of the selected players data.

Each players table will be named the same as the $id.

i'll try to explain a bit better:
A list is created of all players in the user table.
Each player has there own table named the same as there id number.
I would like to select the players from the list that I would like to insert the data to.
Then hit Submit and have all the data inserted into each players table.

If I have $players=$_POST['players'] then $players should be an array containing the list of all players tables I want to insert the data to?
then how do i INSERT INTO $players???

Sorry, its late and im tired, and i am new at coding

Any help?

[mmonaco]

It's absolutely incorrect to have a table for each player. Your tables should not be dynamic. I don't understand your relationship between players and users but make a single 'players' table with a field 'user_id'. This is how you establish the relationship between a player and a user.

I'm not even sure what you're problem is but fix that first before you try and solve anything.

[FatRat]

ok, further explanantion.

i have a user table that contains the id, username, email, etc. A basic profile table.

i also have a table that contains a list of matches, dates, score, etc.

i would like to be able to award each player points for playing in matches, and be able to show the player which matches they played in.

So i thought i would create a table for each player, and then insert into that table the match id of each match the person has played. Aswell as doing this for matches i wanted to do it for practices and some other things, so each player would have a table of matches/practices/whatever that they have played in.

then from that table, which would include points for each match/practice i could calculate the total points each use has and insert it into there profile

[FatRat]

having thought about it, i could create a new column for every user on the match table

ie, match id, match date, match result, me, you, him, her

and then when i want to give ppl points for the match i can just insert points to those fields.

How do I use the array players[] that I made from the form, which is a list of players created from using checkboxes to insert into multiple fields? I would want to update multiple players fields for 1 match row.

something like this line in a 'while' loop
UPDATE matches SET players[] = $points WHERE match_id = $id