If you split multiple search terms on a single search up into multiple inserts (ie; "my best dog" would result in three inserts) then you could do a COUNT(*) AS C and a GROUP BY TERM, ORDER BY C DESC, TERM or something like that.
That'll do yer. BTW, if you want to be extra sneaky, if the site has logins, also save the userid. Then you can let users know what their top ten searches are (like Google) and allow them to click on them to revisit their search results. Auto bookmarks! Mik At 01:38 PM 8/23/2007, you wrote: >>I just log the term and the date. So one row per search. This then >>lets me do stuf like top ten search phrases. > >Wouldn't you need to search for the phrase first and increment a total? >Otherwise you'd have "naked" on 90,000 rows :-) And the date only refers to >the last time, so not so helpful, no? > >That's why I was thinking a file might be better. > >?? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
