Hi All I've got a little problem I'm toying with and was just wondering if you have any thoughts. I've got a hit counter thingo that I've knocked up with CF and MySQL. We run it on a few of our sites. One of the *features* of it is you have a table of IP (two cols, a unique id and an ip field) that you generally don't want included in statistical output. This is for blocking spiders, etc.. Each site has its own exclusion table in its own datasource.
What I want to do is regularly merge all of these tables and am a bit stumped as to how to do this. Ideally I would want a master table that all of the stats collectors & reports use, but I need the one in each datasource for querying purposes. What I have thought of so far is that I set one table as the master, do periodic checks on what IPs have been added to the slave tables and add these to the master. Then drop all the slave tables and recreate them mirroring the master table. This seems kind of overkill. Is there an easier or more efficient way? Cheers Mark ______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 www.gruden.com --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
