I know now that my database design wasn't too good when I made my articles script but... I can't (be bothered?) to change it now, so anyway. I have a table it has fields a bit like this.
Writer | Title | Content | Date Written
there are more but they are irrelivent. Basically, what I want to do, is grab the name (writer) that appears the most often in the table, the most prolific writer, if you will.
I have been told by several sources that this can be done with the GROUP comand, but I'm still not sure how, if somebody could tell me how it's done, and possibly, if they have time, give me a brief explanation of how GROUP (BY) works, I'd be most grateful indeed