Calculated field in MySQL

database perfectn_se ======================================================================================== ======================================================================================== Table: se_educations Field: education_user_id education_name education year points = 5 for each record max 5 points ( 1 record) another record stored somewhere in a new table [se_completed_profile] preferably will store the missing field and table name the result needs to be in normal english to be usedon a new php pop up screen which would state Position for [education_name] is empty all these fields will need to be displayed in a pop up ======================================================================================== ======================================================================================== Table: se_employment Field: employment_user_id employment_employer employment_position employment_from_month employment_from_year employment_to_month employment_to_year points = 5 for each record max 10 points (stop counting points after 2 records) if all the listed fields have data then all points are given another record stored somewhere in a new table [se_completed_profile] preferably will store the missing field and table name the result needs to be in normal english to be usedon a new php pop up screen which would state Position for [employment_employer] is empty all these fields will need to be displayed in a pop up ======================================================================================== ======================================================================================== Table: se_user Field: user_id user_photo if not empty 40 profilevalue_2 phone 10 profilevalue_5 city 10 profilevalue_4 state 5 profilevalue_11 zip code 5 profilevalue_1 country 5 profilevalue_15 what i want (if character count <250 then 5 else 10) profilevalue_14 what i do 10 profilevalue_49 who_i_am 10 profilevalue_42 first name 5 profilevalue_43 last name 5 profilevalue_44 referrer first name 5 profilevalue_45 referrer last name 5 profilevalue_24 business name 10 profilevalue_52 title 10 profilevalue_23 email address 10 profilevalue_27 website url 10 if all the listed fields have data then all points are given another record stored somewhere in a new table [se_completed_profile] preferably will store the missing field and table name the result needs to be in normal english to be used on a new php pop up screen which would state ======================================================================================== ======================================================================================== Table: se_completed_profile Field: user_id total (sum of points from the listed fields) missing fields I need a tpl file that I can include on the profile page. This tpl page must show the percentage of the profile complete. (total/180) this record should contain the total points calculated from above to be display in the tpl file as a percentage. A link must be available which will pop up the fields missing from the profile that are listed above.