Best Way To Do Member Site

[farel]

Hello, I have a question. I am making a hit statistic website and am wandering how I should setup the table. right now Im thinking of these

1. Member Table (has information such as member name and pass)
2. Member Status Table (has variables updated saying if they are prefferred customers or not)

I am wandering since everytime they get a hit the site referrer and and date along with the number of times they've had visitors are recorded. I am wandering would it be best to have the database create a new table for each member for the traffic stats or just have a stat table that has every member and if so would it be slow? Thank You.

[tekky]

general method would be to have 1 member table, 1 stats table that tracks stats by member_id

then to get a members stats, you just SELECT * from stats_Table where id=member_id

and it shouldnt be slow.... having a table for every member... would be DB intensive.... and slower in the long run I would think....