>Create two data tables, one for terms (have an term_ID and search_term >field) and one for search date/time (have a term_ID and date/time field).
I know little about db design, sorry: why would you use 2 tables rather than one with 3 columns? >>Sure it's helpful. I want to know how many times people search for terms as >>it helps me figure out what people are searching for. But your description of the task didn't have a counter. Or would just keep adding repeat entries ad infinitum which can't be good. In any case, I don't see how the lastdate used helps me to do much. The term might not be used for a year, then once last week. Doesn't help to see what has been popular this month. My top 10 might be really old searches. I could query so lastdate must be within a recent period, but no more than that. I guess that's enough if no better solution. That's basically why I was asking what people have done and considered a file for each period. Am I missing anything obvious? The userid tip might be nice but we already have a custom "bookmark" page where the products are determined by users saving them to that page. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4