Forum Moderators: coopster

Message Too Old, No Replies

Count the hits from different IP each month

how to design the table

         

sqlnew

4:24 pm on Jan 24, 2006 (gmt 0)

10+ Year Member



Hi, all
I have a table (url) which counts the number of hits of my sites for each month. Now I want to know how many hits from each IP address for each month. How should I design the table? I want to design the table (IP)which contains 13 columns, the first one is IP, from the second to thirteenth, each column is for a month from January to December, but it is redundant since the url table already has the month columns. What is the efficient way to design the IP table?

Any information is highly appreciated. Thanks in advance.

simon2263

5:12 pm on Jan 24, 2006 (gmt 0)

10+ Year Member



It's not redundant to have the IP table with 13 columns, since it is recording different information! The number of hits for a URL in January is not the same as the number of hits from IP address xx.xx.xx.xx in January.