Newbie to php - Suppose there are 5 fields; field1, field2, field3, field4 and field5.
Fields 1-4 are numeric values.
How do I make field5 the sum of the other 4 fields?
Thanks.
Calculated field
Moderator: General Moderators
Re: Calculated field
Sorry to be unclear. Mysql database - Students receive scores in 4 categories based on their performance. The categories (which are fields in the table) are Knowledge of Music, Musicianship, Tone and Diction. Judges enter the score in each category;
Knowledge of Music - 40
Musicianship - 25
Tone - 25
Diction - 10
Based on that entry, the total score is calculated and the field contents updated with the result.
Total Score - 100
The problem I'm trying to avoid is with judges adding their category scores incorrectly.
Thanks for your help.
Knowledge of Music - 40
Musicianship - 25
Tone - 25
Diction - 10
Based on that entry, the total score is calculated and the field contents updated with the result.
Total Score - 100
The problem I'm trying to avoid is with judges adding their category scores incorrectly.
Thanks for your help.