Hi,

Wanted some help on an web based(.ASP)online quiz application that connects to a DB and selects random questions from a DB - and creates the interface online

Front End For Master Maintenance
=============================================================================
Form For Maintaining Quiz Questions - Available only for Admin ID

Question - What is the capital of Italy
Answers - Copenhagen,Stockholm, Helsinki, Rome
Correct Answer - Rome
Points For Correct Answer - 10
Category - Capitals

Back End For Master Maintenance
=============================================================================
Updates the below mentioned table in SQL Server - name - Quiz

Table - QuizMaster
Fields
Question
Options
Answer
Points
Category

Updates into those fields
What is the Capital of Italy Copenhagen,Stockholm,Helsinki,Rome
Rome
10
Capitals

======================================================================
User Interface For Quizzing

Enter Name
Questions (Drop down with 5/10/15/20/25/30/50/75/100)
Category (Drop down with Capitals/Science/Mathematics/Current Affairs/Business/History/Arts/Literature/Travel/Mixed Bag)

Redirect him to a fresh page

Hi %Name,

You chose to take %Number questions from the %Category category. Here are your questions - enjoy and Best Of Luck.


What is the capital of Italy

Radio Buttons

Copenhagen
Stockholm
Helsinki
Rome

Keep track of score
Number of questions - A of B
Points Accumulated - X of Y

Ask him the number of questions he specified and give him his score on a new page.

If some one can guide me - Thx

Rgds,

KB.