in the database there are multiple records for the same person.
person 1 has 5 entries
person 2 has 3 entries
and so forth.
all im trying to do is get a simple count of who has the most entries from highes to lowest.
i wrote this query it works well for me but im using mysql version 5.1.33 locally.
SELECT mname, COUNT(mname) FROM votes GROUP BY mname ORDER BY COUNT(mname) DESC
the server this will run on uses a older version of mysql. im not sure which one though.
any ideas on how i can rewrite this?