I have a large database of information of characters
This contains "owner", "charactername" & a lot more info
the owner can easily repeat as they own more then one character.
what I'm trying to attempt to figure out how to do is create a list of UNIQUE names and how many times they are listed to own characters
NAME | NUMBER OWNED
jane | 5
john | 21
michael | 15
I have a script that queries the database and echos a list but I am unsure how to make that echo query the distinct 'owner' to count how many they have.
any help to point to an example how to do this would be greatly appreciated.