> > SO I can either do 60 individual queries OR loop through the main query 60 > times to harvest the data I need.
Without question the best way to do this is to use a single GROUP BY query against the DB like Adam Knott suggested. It is much more efficient and readable that 60 individual queries in the application layer. -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
