Ok, I have a database of search strings with which users of the site have hit my search engine. I want to build a viewer so I can go in and see what people are doing without actually cracking into the database. My database isn't doing anything fancy. It's one table, consisting, essentially, of id, searchstring, casesensitive...
What I want is to be able to query the database, and display the 10 or 15 most searched strings. I'm just not sure how to go about it. I can GROUP BY searchstring that get's me close, and culls out duplicate strings, but I don't know how I'd get from there to top 5 strings: 1. Happy and Go and Lucky (16 searches) 2. "Moo Cow" (10 searches) 3. etc. 4. etc. Any thoughts? Willy Ray ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
