PHP used for study

[Ryan_Sanders]

I want to create a PHP script that will randomly print questions that I set for it, then I have to submit the correct answer. This is to help me study for school.

I can code PHP, but I just need some people to help me decide on how about doing this. I don't do flat-file stuff, only database.

I am looking for a structure maybe of how it should be coded.

Thanks!

[devinemke]

assuming there is a simple 1-to-1 relationship between questions and answers, you could use just one table:

CREATE TABLE qa (
  qa_id int(11) NOT NULL auto_increment,
  question text,
  answer text,
  PRIMARY KEY  (qa_id)
) TYPE=MyISAM;

then create a simple HTML form that asks the questions and a PHP form processor that verifies the answers.