php/mysql quiz help

[dink87522]

I wish to build/make a a simple quiz for our office lunchtime quiz. I know enough PHP to be able to customize scripts a bit, but I do not feel confident in writing them on my won. I have no experience with mysql.

This is how I hope it will work:
A question is selected from a database (either randomly from all questions or from a certain category of questions i.e. Music category). That question is then displayed and the user gives their answer through a form. The answer is then checked against the stored answer in a a mysql databse to see if it is correct.

Bear in mind that I'm not very qualified, how do I go about building something like this or can anyone help get me started?

[djjjozsi]

on the internet there are good test and quiz scripts.

4 example:
http://webtester.us/wtdemo.php

if you want to make of your own, you can start build the mysql table with my php/mysql code generator. 🙂

you have to decide the answers type( yes or no question, or choise from 4 values, free word input)

but if you wanted to make complicated program, that cause exponentially complicated structure (mysql table structure and those queries).