[Average?]

thanks guys

[Average?]

Anyone know how to get that average?

[Average?]

Hmm, what do you mean by inserting the values before the calculations?

[Average?]

I want it to calculate \"all by itself\"

 

The skill, activity, pedi, info and design values will be inserted from outside and when they are inserted I want mysql to input the average in the right column.

 

I looked around and saw that there\'s an average function in mysql but with my low mysql skills I don\'t know how to use it.

[Average?]

I have a a few columns containing numerical values. I want to have a column that would contain the average of some of these columns.

 

I have a picture, maybe it\'ll explain it better.

 

 

I would like the \"webave\" column to contain the averages of \"info\" and \"design\" columns.

 

and I\'d like the \"totalave\" column to contain the average of \"skill\", \"activity\", \"pedi\" and \"webave\" columns.

 

Is that even possible?

 

I\'m a newbie at this database stuff so please be easy :?

 

Regards,

 

Tony[/img]