I have a series of drop down menus such as:
Menu One:
- Select one please...
- Basketball
- Soccer
- Golf
Menu Two:
- Select one please...
- Basketball
- Soccer
- Golf
Menu Three:
- Select one please...
- Basketball
- Soccer
- Golf
And each of the three list items corresponds to a value (For examples say, 1pt, 2pt, 3pt respectively).
Now I've been trying to wrap my head around on the best way to have it so that if a person selects Soccer and Golf, it would then tally the total and submit it to the database. (Total being 5pts)
It also has to recognize when a field contains 'Select one please...' and count that as 0pts.
I've been trying to just do it with simple math functions in PHP, calling each sport's value when called then trying to add them but it gets mucked up when I have any of the 0pt selections.
Any suggestions on the best route to make such a tool?