using PHP to categorize links and send results to mysql db

[grungefreak]

Hi,

 

I am trying to develop a prototype as follows:

 

This is an online course in teaching  Java programming.

The user has the choice to follow a specific path throughout the lesson e.g. view some video tutorials, use the interactive quizes, just read text etc.

Based on the decisions (links clicked), the system will then build a user profile of this persons learning style e.g. a visual learner, interactive learner etc.

 

I am just setting out with this so I want to ask you the followingL

 

Should I assign a value to each link and then send the result to a user profile table in my database?

 

Or is there a better approach?

 

I want to export the contents of my database and analyse the results using SPSS or PASW as it's now known (it's a statistical analysis tool that identifies clusters e.g. in this case, it will take the results of my databse on csv format, import them and identify cluster groups from this).

 

Hope I haven't been too long winded but any guidance or suggestions, links etc would be most appreciated.

 

GF

[lemmin]

I would have a simple two column table for pageID and userID to relate what pages the students go to. On each page, you can have the database insert current userID and pageID, ignoring duplicate entries.

[grungefreak]

Cheers. I like that idea. All suggestions welcome.

 

GF