|
Thanks for the replies. I powered through and figured it out.
One db and three tables.
IP TABLE: so I don't insert the same ip multiple times and add size to the db
CLICKS TABLE: records validated trade traffic clicks on inbound. Recording the from site, to site, unique ip id to track for raw/unique,
TRADES TABLE: free site trade data, I.e. domain name, url, id, and account contact info.
I never built anything like this before. It's pretty intense, frustrating, yet satisfying once you break through. The queries were the biggest challenge. "Get all clicks to this domain from all trade domains, except this domain, count clicks, sort count array, create link list"
It's pretty cool though, a one page wonder that I can include a top any free site on my server. It prints out a list that can later be echoed anywhere on the site.
Sorry for the brag, it's 3:30 am, I am jacked on coffee, and ecstatic with php success-ism!
Maybe the above logic helps someone...
|