Multiple Choice Website

I am after a php driven website drawing on data from a mysql database. It will be a multiple choice website that would initially be free but eventually be able to charge for a subscription via paypal once I had built up enough material.

Essentially there would be a database of mcq questions (best of five). Once candidates have registered they will have access to the bank of questions with the site keeping a record of which questions have been answered by that individual (and whether they have answered correctly).

There are 14 different topics. At the beginning of the session the candidate should be able to specify whether they will either answer questions randomly selected from the whole database (All questions) or answer questions randomly selected from a specific topic or combination of topics (Topic A and/or Topic B and/or Topic C etc). This would be done by selecting tick boxes.

At the beginning of the session not only would the candidate select what topics they would answer but also be allowed to apply another filter - questions not yet attempted (the default option), question attempted but previously marked as incorrect, all questions whether previously attempted or not.

Once the candidate started answering questions, each page would be php driven extracting the question text from a database (mysql or alternative mechanism if you feel there is a better option).

On reading the question text the candidate will select one of five possible answers. They then click a submit button whereby additional text is added to the page being viewed giving a statement of whether they answered correctly and a further few paragraphs of explanation. A next question button is clicked to progress and the process is repeated.

During this process the progress for that session will be displayed in the corner of the page stating how many questions have been answered and what percentage they have got right.

As part of the home page that is viewed once logged in, the candidate would have usual options to view account information and also a results breakdown page showing how many questions have been attempted from each topic and what percentage they have got right (compared to population of other people who have also attempted that question) . There will be an option to reset progress so they can start all over again if they desire.

There is a website that I would like similar function to (details can be provided to bidders) but the presentation different (screenshots of how I would like the site to look will have been attached to the brief). There should be an admin interface so I can upload each mcq as I write them which should then be added to the database.

In the add question part of the admin section there should be sections to enter in the question text, the correct answer option and the explanation text. There will also need to be a facility at this stage to indicate which topic that question pertains to allowing the question to be served to the candidate given their filter selection.

There would also be the usual admin facility to manage user details. A time and date of registration should be included in user information to allow an automated email to be sent when 1 week of use remains and then automated termination of access following a specified period of time. As the website will initially be free, candidates will be allowed to register for 3 months at a time. When the site starts to take paid subscription those that have registered for free will run out their 3 months before automatic termination and would then have to pay to renew subscription.

I should also be able to modify questions I have already written or delete if required. The application should also allow me to include images (which don\'t need to be protected) in either the question text or the explanation text when supplied (after the candidate has attempted the question).

I require an estimate of the cost of the project and likely timescale. Spread of payment will be via staged payments. Quality and \'cost limitation\' is to take priority over time scale (within reason).

There is likely to be further functionality added in the future so further work is probable. An indication of whether the freelancer would be willing to take on further contracts is desirable but not essential.