table design help needed

I have a gamming website. I have pages which displays data from other clans.

Members need to register and login to view full clan details. User who have not logged in can only view partial data.

Now I need to keep track of the kind of hits each page received. That is I want to tell clan say X that these particular members viewed your page these many times and on these dates and these members who have not registered have viewed your page these many times and on these dates.

I am using ASP with MS SQL.

I would like some help on designing the tables and layout that is efficient.

Any help will be appreciated.

Couldn't you have a code identify if the user is logged in or not and--depending on which--is directed to a different part of the page (probably using ASP cases). Then on each part, have it find the number of hits...?

Each page need to check user login details. you might need to use an include file for this if you have many pages.
Don't forget to have case-sensitivity in your password field in your login table, though. You need to take your time
designing this db; it will save a lot of your time in the future.

I would suggest you create a separate table for the hits of the page; say HitsTable or tblHits which will have
the pageID (foreign key to the Pages table) - the visited page, MemberID (foreign to Members Table) - the member
who visited the page and Date and Time. The memberID of the guest should be unique; just select a number that you
are sure you won't have in the Members table as the member ID. [I think 0 {Zero} would be fine or just a negative number].

thanks for your help.

My main concern was the table design so that I have just the required information and do not store unnecesary info to as to fill the DB quickly.

I have it up and running