Käynnissä

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.

Taidot: PHP

Näytä lisää: mysql calculated field, calculated field mysql, mysql calculated fields, mysql city state database, education first, education city, country state and city database mysql, city year, total field mysql, php mysql count percentage, mysql calculated fields statement, calculate fields table php, mysql calculated field howto, mysql field calculated, calculated fields mysql, character count data field mysql, mysql stored calculated field, calculated field table view mysql example, mysql table calculated fields, mysql update record calculation fields, calculate mysql field, Profile Title, tpl, counting, field php

About the Employer:
( 38 reviews ) north richland hills, United States

Projektin tunnus: #443789