How to create a log script

predator

Hey,
I would like to create a script where I could track down people that visit the site.

This is how the procedure would go

1) They login to the site
2) They answer various questions
3) They logout

What I would like to keep track of is
Who has logged in?
When did he log in?
When did he log out?
How many questions did he answer?
* How many were false/correct?

Obviously, I need to have a bunch of tables both for the login, the questions and so on.

I'm writing this because I would like to be inspired on how I could solve this log script?

Could someone give me a suggestion how my table could look like?
Something like this could work I suppose
LogID
UserID
Login (DATE-TIME)
Logout (DATE-TIME)
Questions
CorrectAnswers
FalseAnswers

To explain a bit more on these questions - there are mathematical and the user will have 4 options, if he answers correctly he'll be redirected to the next question. Does anyone have an idea how the log could keep track of this?

Any input, any ideas at all, or if someone perhaps has a similar log script that I can further develop.. or a good link, I'd appreciate a bunch!

Shrike

table users

user_id (int, primary key, auto_increment)
username (varchar)
password (varchar)

table logins

user_id (int)
login_datetime (datetime)
logout_datetime (datetime)

table questions

user_id (int)
q1 (int 1 true 0 false)
q2 (int 1 true 0 false)
...etc...

Keep your tables as distinct as possible, this should help future development and allow easier reporting etc. For example the questions on the site have nothing to do with the login, so keep them separate.