the table looks something like :
ID | ARTIST | TITLE | AUTHOR | ALBUM | HITS | POST
well the author column has the name of the person who posted that
well i want to do is display who has posted the most .. like Craziest Poster : blablabla ....
i tried :
Code: Select all
SELECT author, COUNT(*) AS top FROM table GROUP BY author ORDER BY top DESC
gives me an error .. any help would be apreciated