buladex Posted July 21, 2010 Share Posted July 21, 2010 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 Link to comment https://forums.phpfreaks.com/topic/208451-help-me-make-this/ Share on other sites More sharing options...
buladex Posted July 21, 2010 Author Share Posted July 21, 2010 SELECT event,SUM(data) FROM xxxx GROUP BY event how i add rank? Link to comment https://forums.phpfreaks.com/topic/208451-help-me-make-this/#findComment-1089231 Share on other sites More sharing options...
fenway Posted July 23, 2010 Share Posted July 23, 2010 You'll need user variables. Link to comment https://forums.phpfreaks.com/topic/208451-help-me-make-this/#findComment-1090350 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.