PHP Quiz

php, quiz, mysql

[watthehell]

Hi,
i need help for a php based quiz, it is for my coll. project :::
anyone interested please help me .............

the project is like this ::::

there is a topic for test , the admin can enter the questions and answer , there are 5 category (test 1 to test 5)

each tests contains 20 questions and each question can contain 2 to 4 answers depending how the admin enters the no. of answers, each questions also needs to have a image to give hint to the answer (image is not mandatory ).

I need help in designing the database, how shall i design the database , i had made two tables one for questions and one for answers, but there will be 100 questions for 5 tests?
please help..........please anybody

[Habtom]

A not so bad username, specific questions and more effort from your side, might have encouraged others to help you.

[edited by: Habtom at 9:23 am (utc) on July 8, 2007]

[watthehell]

abt... the username : i found all others reserved ::: so that's not a big thing, it doesnt reflect anything and does not mean offense to anyone ;)

and talking abt the specific question : i could not design the db so nothing to ask in detail now :::

maybe i need to find another good forum ;)

[jatar_k]

Welcome to WebmasterWorld watthehell,

try 3 tables then

tests, questions, answers

all tables should have a unique id to identify each row

answers could contain the actual answer and possibly your image link

questions could have the answer id and the text question

tests could have a list of ids for which questions belong to which tests.

something like that though it would probably take some further tweaking