I have a wee problem....im trying to set up a fantasy football site, and in order to update the weekly scores Im setting up a Form.
I input the results into the form, These results include the following data for each game:-
Players and subs
Scorers
Own Goals
Yellow Cards
Red Cards
Team win/loss...etc
This is completed for each game, then the system works through the database using a series of looped queries to allocate the points to the individual players and members teams.
Ive started to go about this by setting up the form using checkboxes and sending the input to a process.php file, where each $var is allocated a certain score. For example:
//if a player plays and team wins
if($First11 & $scored > $conceeded)
{
Update "tablename"
SET "blah" = "blah" + 4
WHERE playerId = $First11;
}
Im not good at any scripting language, therefore this is a huge challenge to me! My question is this:
Is there an easier way of approaching this, i.e. do I set up the form differently, or should my process.php be totally revamped as its a load of crap!!??
All hints and suggestions are greatfully appreciated.
Thanking you
