Hi Warren,
What I personally would do is simply include some sort of 'ID' field. In
other words, each question would have a unique ID. Question 1's ID would be
1, Question 2's ID would be 2, etc. Or however you wanted to number them.
You could even set this up as an auto_increment and have t
You need to re structure it using a table called say Questions with the
following sorts of fields
QID Id number
QTitle Title eg Question1
Q The question text
A The answer text
R The rank or score of the question
That way you add questions simply by adding records to the table.
you might find the
Hi,
> I have a Test Questions database. Right now I have a hard-coded limit of
> 200 questions in it; I actually made a table with field names like Quest1,
> Quest2. . . Quest200. However, I know that I am not using the power of
> MySql in setting it up this way. This is more an example of m
