help me make this!!!

[buladex]

this a  new project im thinking off:

 

i have this table:

 

 

id          player_id    player_name    event  type  data

92286 15091851 xxxxx1               971 1     57

92287 15099758 abc                    22 1     2

92288 15099758 NightKing             22 0     11

92289 15099030 ~Barbie_Girl~       1 18   30

92290 15093867 (*maximo*)           1 1     27

92291 15096966 atwa522               1 18   93

 

 

and i need it to look like this (php script):

 

rank(depends on sum of data)  Player                                Points

 

  1                                                Player1 (he = event 1)    150(were event =1 sum of data)

  2                                                Player2(he= event 22)      13(were event =22 sum of data)

 

 

can any 1 help me?!!! please

also it can have predef player like player 1= event 22 player 2 = event 1

[buladex]

SELECT event,SUM(data) FROM xxxx

GROUP BY event

 

 

how i add rank?

 

[fenway]

You'll need user variables.