Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WHAT tables are required?

Status
Not open for further replies.

fparty

Programmer
Nov 17, 2011
9
GB
Hi

Trying to think this one through so a bit of help of you guys may solve it.
I'm need to create some clicks off sites, these links will come from different sites so i want to know which and how many clicks are being gathered

my simple URL is
index.asp?page=count&typeid=2&identity=1

count calling the redirect function, typeid is the company it belongs to, identity being the place from where the click happened.

So what are the best tables to contruct? i want to view these in an admin page so i need to see

click count per banner lets say 2 for now, and which sites the clicks came from lets again say 2 for simplicity?

What is my database design going to be.. i wnat it simple so i can constuct a view inner joins to view on a formatted page

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top