A few days ago, I was generating some XML to feed a video player. I would grab a list of the last 20 uploaded videos, then grab the categories associated with each video to create a set of "tabs" for the player. For instance, five of the videos may belong to the "high_school_football" category, so we would have a "High School Football" tab containing five videos. I then needed the categories to be ranked by the number of videos in each.
Posted by brutimus on October 6, 2007