What's the easiest way to output a list of items plus the number of times they're listed? I want an output like Item - (count) For example: I have three downloadable scripts listed in my database. I have one table that lists the item and each time it was downloaded (along with other info, but those are the parts that matter) I want to query the list so I can output something like: cfx_coolscript - Downloaded 23 times cfx_coolscript2 - Downloaded 154 times cfx_coolscript3 - Downloaded 1 time Is it possible to create a list and a count in a single query? I'm aware of creating an incremental count field in the database and simply displaying the value, but I want to know if there's some query/math solution too. Thanks. ================================ Josh - [EMAIL PROTECTED] ================================ _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
