I'm new at programming with PHP/mySQL and I have got a little problem here.
This is how my code looks like:
SELECT COUNT(*) AS Number , Name FROM table GROUP BY Name ORDER BY Number DESC LIMIT 100
Out of this table:
Oliver Michael Oliver Steven Michael Oliver Oliver
... it generates:
Oliver | 4 Michael | 2 Steven | 1
My question: How can I add ranking numbers so that it looks like this:
1 | Oliver | 4 2 | Michael | 2 3 | Steven | 1
Thanks for your help!