March 28th, 2004, 09:53 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
php/mysql - simple math problem
I'm not good enough with mysql to figure this out.
I have a table :
Name - (varchar)
Result 1 - Decimal
Result 2 - Decimal
Country - (varchar)
What I want is a php script that calculates the averages of result 1 and result 2 respectivly for each country and
enters them into the database in 2 more columns. for example
NAME R1 R2 Country AvR1 AvR2
Jim 3.21 4.13 USA 1.76 3.12
Zak 2.12 2.11 UK 2.62 ..etc
Boo 3.11 1.02 UK 2.62 .
Josh 0.32 2.12 USA 1.76 3.12
Im not clever enough to figure it out tbh.
Any ideas?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
