Help on PHP MYSQL, give point to result

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
hamedx
Forum Newbie
Posts: 8
Joined: Wed Aug 20, 2008 9:38 am

Help on PHP MYSQL, give point to result

Post 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
Post Reply