Reclassification

[Anon]

I have a database of questions consisting of 2 tables, one of different classes of questions,Easy and Difficult. How can i get the questions to be automatically reclassified from one table to another, eg. if the question is answered INCORRECTLY 80% of the tries,and it's from Table 1,Easy questions, and i need it to be automatically moved to Table 2,Difficult questions?

[gio2k]

Hi.

First of all: Why do you keep two different tables to store the questions?
Im my opinion, you would have much less trouble by puting them all in one table, and using a field for telling them apart. Like this:

create table questions
(
qid integer unsigned not null auto_increment,
qdesc varchar(255),
qtype char(10),
primary key(qid)
)

Where qtype can be either: 'EASY' or 'DIFFICULT'
( You can use any code you like for classifying the questions, like 0 and 1. I personally prefer to use values that are understandable)

With a table structure like this you would only have to update the records with question type = 'EASY' with 80% or more incorrect answers to type = 'DIFFICULT'

I am suppposing you have another table where you store the answers or the results, and that you can calculate the % of wrong answers.

HTH

-Gio-

[Anon]

Thanx for the advise,it never occurred to me to store all Questions in one table, You see i just completed a beginner's course in VB 6 and i have a project to develop a test-simulating program that that reclassifies questions according to % it's answered wrong or right. I have another table where i stored all the answers, but i don't have the code to make comparisons between the answers submitted and the the actual answers stored in the table in order to automatically reclassify the questions.
I would really appreciate any assistance in this regard.
Thanx

[gio2k]

Can you post the structure of the tables?

-Gio-