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).
In the terms table check to see if the term is there. If it is get the term_ID and update the time table with the term_ID and date. If it is new, add the term, return the ID, then update add the date/time and term_id to the date table. Now you have two tables: one with unique terms; another with date/time of each search... linked using the term_id as a key. I think this is the most flexible way you can do it. Do it this way and you should be able to write queries and reports to analyze that data pretty much every way possible. Is this explanation understandable? Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:286982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
