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 Quote 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? Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/208451-help-me-make-this/#findComment-1090350 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.