Quiz version 2
Requested by a quite surprising number of people, my little Quiz application had some success.
You can have a look at the way it works on the website Scoilnet (go to the Primary kids section to see it in action)
I decided to publish a more complete version, with this time an Admin tool to manage all the Quiz database.
I build this tool around a single table in a SQL database, but it's very easy to change to any Access or MySQL database.
I could certainly obtained a better realtionships model using few tables, but I would like to keep it simple and easy to move from one project to another.
That's why I used an old trick (remember Dbase III ?), and simply use concatenated strings to store multiple records in one field.
I reckon that it was a difficult story to write a decent user interface to manage the different fields and the data.
I will publish an article in my blog tomorrow, and also the full project with a zip file.
Of course, if you need more explanations, or if you have some interesting ideas on the subject, feel free to comment.