Hi,
I'm currently developing a website where each registered user has to pass some tests.
I want to track each user's progress:
That is, for each user I want to know which tests he passed, when he passed them, after how many failures, etc...
I'm using a MySQL database, and I'm wondering where I could store all these user info.

What do you think?

Thanks in advance,
Hamza.

Do you want to check the sql-statements a user has done or do you want to know the web-sites (each web-site is a test) the user has visited?

Greetings,
Markus

Hai,

You can store the user details in a seperate table called users where each user will have a unique userid (primary key),
then store all the details abt the test in a seperate table, and the test results in a seperate table,

The following is a rough schema,

Userdetails
----------

userid,(primary key)
fname,
lname,
(any other details like email..)

TestDetails
-----------

Testid,(primary key)
testname,
testdescription,
(any other details for test)


TestResults
-----------

resultid (primary key),
userid,
testid,
status (pass or fail)
date,


To find out when the user took the test and to check the result of the test u can query the testresults table...

Hope this helps...

Thanks for your reply.
If I have for example 5000 users and 200 tests, I would have 1 000 000 entries in my table. Will this be a problem? Is that too much on MySQL?

Thanks again,
Hamza.

hai..

I have used mysql with well over 2000000 and have not got any adverse performance problems. So i hope 1000000 will not create any problems for u.
By the way is 5000 users and 200 tests is the maximum count expected or is the minimum count expected ?

5000 users and 200 tests is the very maximum expected

Thanks your help,
Hamza.

So no probs...Go head and implement your db in MySQL and i am sure MySQL will be happy to give u the performance that u need