Page 1 of 1

Help on PHP MYSQL, give point to result

Posted: Fri Apr 23, 2010 7:31 am
by hamedx
hi experts , im designing a result of game program that get the "time" of players from own team and giving to them the right point ,but the important thing is the 2 of 3 players of team going to get point , for db example :

teamID - playerName

1 - nameA1 ----> point=100
1 - nameB1 ----> point=90
1 - nameC1 ----> IGNORE
2 - nameA2 ----> point=80
2 - nameB2 ----> point=70
2 - nameC2 ----> IGNORE
3 - nameA3 ----> point=60
3 - nameB3 ----> point=50
3 - nameC3 ----> IGNORE

and this example :
Image


as you see this , in team column there is 3 "Heyat Kerman" and only 2 of them (red color) going to get point and the point of (black color) == 0
so how can i do this ?
thanks