contex Posted January 24, 2010 Share Posted January 24, 2010 Hello, I'm trying to get some values from my database. I have table called deaths: id | date | victim | victimid | murderer | murdererid What I would like it do is to get the top 5, with the most kills, and deaths from the list. So for every death, there is a new insert in the table, so if murderer "Thekiller", has killed 14 diffrent players, and another murderer "TheNazit", has killed 9 diffrent players. This would put "Thekiller" on place no. 1, and "TheNazit" on place number 2. Any ideas? Link to comment https://forums.phpfreaks.com/topic/189588-sorting-out-a-rowscount/ Share on other sites More sharing options...
fenway Posted January 25, 2010 Share Posted January 25, 2010 You mean a GROUP BY, COUNT(*) with an ORDER BY clause? Link to comment https://forums.phpfreaks.com/topic/189588-sorting-out-a-rowscount/#findComment-1001265 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.