most values

[Anon]

hi! i'm having this thingie i'm been trying to make and as i'm a newbie i dunno how to solve it 🙂

so: i have a mysql database where i have values like name and some text etc. and most names exist there multiple times. so i'm trying to do a script that shows which names exists there most often. any ideas? i crashed on a thing where i wasn't able to do an array which would have every name only once.. thanks in advance!

[bacil]

select count(*) as how_many,name from your_table group by name order by how_many DESC

this should solve your problem.

this query counts how many same names are there and orders them descendig...

result is a table with two columns

17 | Joe
14 | Bill
10 | Peter
10 | Vlado

have a nice day...
Ivan

[Anon]

thanks, that'll do it 🙂
didn't guess it was that easy 😃