Hi all... I'm setting up a form to upload my fantasy soccer league formations to a db table named "formations"; as I am new to php/mysql before making all the job I would like to have your suggestions....
the fields are id_s, id_g, use, use#, timestamp
where
id_s is the id of the team
id_g is the id of the player
use has 3 possible positions : field, bench, out to mark if the player is on the starting 11, on the bench or not playing
use# has 3 possible positions 0, 1, 2; the lowest numbered player in bench will be the firstone entering in case of substitution
the form has 24 players coming from a SELECT query; every single row will have a single player name,id_g and id_s coming from the PLAYER table (id_s and id_g will be hidden), a 3 value RADIO BUTTON (field,bench,out) and a 3 value SELECT (0, 1 , 2); then it will INSERT to DB id_s and id_g as hidden fields, use and use#.
The inserted formation will be shown in a new page through a SELECT....
This is basically the idea but since I'm quite new to php/mysql should I use any particular trick ??
I think that the problem will be the radio button and the select (0,1,2) field: will it pass the different values or ONLY THE LAST ONE ??? If so, how to make a workaround to this ???
Also I read in some post to echo the results to a page in order to check the values passed... HOW CAN I DO THIS ??
Thank you for all your help !!!!
Roberto
