MySQL & PHP Quiz Database

Please Help!

[Ellason]

Hello, I am looking to create a web based quiz system. There will be two user accesses, one for teacher and one for student. The teacher will be able to add new questions to a bank of questions stored in a database table and the answers of the questions will be stored in another table. The questions will be multiple choice.In order to create the quiz for the students to complete, they will select the questions from the question table and select four possible answers from the answer table, one of them being the correct answer. The quiz is then added to the system. The students will then answer the questions of the quiz and the answers will be stored in a database table. The student can then view their results of the quiz and the teacher can view the students progress.

So my question is how do i go about doing this?
I know how to create a html form which allows teachers to add questions and answers to a question and answer table in a mysql database. but how then do i create a quiz using these questions and answers?

Any help will be greatly appreciated!

[bkeep]

I think there is already a script that does this with some modification and its called moodle

"Moodle is a Course Management System (CMS), also known as a Learning Management System (LMS) or a Virtual Learning Environment (VLE). It is a Free web application that educators can use to create effective online learning sites."

Yu should be able to make that perform as requested.

[Ellason]

Thanks for the reply. I've had a look at moodle, But I have to write all the PHP scripts from scratch. I am creating the webpages in Dreamweaver and using a MySQL database. It is for a uni project.